“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=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

Im trying to write an equation along the lines tan^-1[((18-12.75)/8.75)-tan(51.534) and the answer should be 33.373 degrees im not sure what the issue is?

Solved by C. A. in 12 mins

I need to delete additive inverse of numbers in a huge data file.!

Solved by K. Q. in 26 mins

I need help writing a formula which is basically the inverse of another formula.

Solved by G. F. in 21 mins

I need to know the formula/symbol for tan-1

Solved by X. A. in 27 mins