Forum Discussion
Excel 2016 tan cos sin formula problem
In calculator Tan(74.7) = 3.6553843546 But in Excel 2016 Formula =Tan(74.7) = -0.839256394 In calculator cos(94.06863367) = 0.0709513889 in excel 2016 cos(94.06863367)=0.983996237385602 So...
Hi,
If in Excel you use
=TAN(74.7*PI()/180)
it returns same 3.65538435465226
Calculator takes degrees, Excel - radians
Forgot what Excel has RADIANS() function, thus that could be as
=TAN(RADIANS(74.7))
- Thanks! Neat solution. Hopefully Microsoft will get around to documenting some of this more clearly.
