Get instant live expert help on I need help with pi/180
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
=ATAN((COSB2*PI()/180)/(TANA3*PI()/180))
Can you tell me why this formulae that I have put into XL is showing the result #NAME?
I want to calculate the value of inverse tan of the cosine of cell B2 divided by the Tan of cell A3. I need the answer in degrees not radians.
I have a range of cells that I need to do this operation on
Can you spot the syntax error I am making?
Cheers,
John
Solved by K. Y. in 29 mins
Hello I am trying to convert a written formula into Excel but not having much joy! Please see below, is there anything obvious that I am missing?
=(F$2/sq(F$3^2+10^4*pi^2*F$4^2))*sin(100*pi*A2-tan^-1(100*pi*F$4/F$3))
Your help would be greatly received :)
Solved by O. S. in 28 mins
how do i use pi functions in developer tab?
Solved by A. S. in 12 mins
SUMPRODUCT FORMULA IN EXCEL
1 2 3 4
Qty Rate Qty Rate Qty Rate Qty Rate
10 200 5 190 5 180 5 180
Solved by A. A. in 26 mins
i cant calculate sin(20*pi*0) 0-80 i need some assistants
Solved by A. F. in 20 mins