Excel 2016 tan cos sin formula problem

Copper Contributor

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 Please Help Me

3 Replies

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.