- $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ - - - - - - - - - - - - € - - - - : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off ( ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - - . / - $ - $ ( ) - $ $( ) $- ( ) - $ - . . WAHR WAHR FALSCH / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - - - - - % : : : : : : - $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 ATAN Function Result TRUE Sheet Result Description 1 TRUE Simple ATAN formulas with local references and values Function Expected Correct FunctionString Comment 0 0 TRUE =ATAN(0)/PI() #DIV/0! AA 0.7853981634 0.7853981634 TRUE =ATAN(1) 13 AA -0.25 -0.25 TRUE =ATAN(-1)/PI() -0.7853981634 -0.7853981634 TRUE =ATAN(1-K20/J18) -0.463647609 -0.463647609 TRUE =ATAN(-0.5) TRUE -26.5650511771 -26.5650511771 TRUE =ATAN(-0.5)*180/PI() FALSE -26.5650511771 -26.5650511771 TRUE =DEGREES(ATAN(-0.5)) #DIV/0! error TRUE =ATAN(J2) 1 0.7853981634 0.7853981634 TRUE =ATAN(J6) #N/A #VALUE! error TRUE =ATAN(K2) 3.1415926536 0 0 TRUE =ATAN(F1) 1.5707963268 1.5707963268 TRUE =ATAN(J13) AOO#97605 1.40E+154 1.15 2.2 2.3 2.3 4 O5