=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