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:
1751