I need to calculate a Trig Angle using the equation;
= (Tangent to -1 Power) X (Cell A / Cell B)
So far I'm getting errors no matter how I enter the POWER and TAN commands.
POWER (TAN, -1) errors.
Any other way to do this?
MacBook Pro, iOS 6.1.3
Also remember that the spreadsheet trig functions use and return radians, not degrees. The DEGREES function and RADIANS can be used do the conversions.
Also remember that the spreadsheet trig functions use and return radians, not degrees. The DEGREES function and RADIANS can be used do the conversions.
Hello
Perhaps you're talking about arctangent (inverse of tangent) and not tangent to the power of -1?
tan^-1 (y/x):
If so, the correct formula in spreadsheet is either
=ATAN(y/x)
or
=ATAN2(x, y)
Regards,
H
How To Do a TAN To the -1 Power In Equation Editor?
