Returns the arctangent of a number in radians.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
ATAN(number)The ATAN function calculates the arctangent of a given number, returning an angle in the range -pi/2 to pi/2. To convert the result from radians to degrees, you can use the DEGREES function.
=ATAN(1)Result: 0.785398163
Returns the arctangent of 1, which is pi/4 radians.
=DEGREES(ATAN(1))Result: 45
Converts the result of ATAN(1) from radians to degrees.
The ATAN function returns an angle in radians between -pi/2 and pi/2.
You can wrap the ATAN function in the DEGREES function, like =DEGREES(ATAN(number)).