Previous Next

## Mathematical Functions in Excel

If you are studying (or not), then you will know what sinus, cosinus, logarithms, etc... are.

Excel lets you calculated theses ones too.

For the trigonometric functions the angle should always be in radian. Radian = Angle in degree /180 x Pi. Where pi is 3.1415926.....

The formulas are Sin(C3), Cos(C3), Tan(C3), Log(C3), Ln(C3), etc...

Interestingly, you can see the imprecision of the formula when for example we calculate the tangente of 90deg. The result should be infinite but Excel does not know infinite.

Tip: An infinite result, for example when you divide something by 0, will give the message #DIV/0!

Previous Next

Updated December 29th, 2010

Contact: admin@Excelmadeeasy.com

You are visitor no:
349