Forum Discussion

JimMac's avatar
JimMac
Copper Contributor
Jan 02, 2022
Solved

IFS formula

Hi, I'm trying to calculate the angle clockwise from the positive Y axis from two points stored an columns A and B. These values can be positive or negative. I'm using the formula ATAN(A1/B1) *180/...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Jan 02, 2022
    =ATAN(A1/B1)*180/PI() + IFS(B1<0,180,A1<0,360,TRUE,0)
mtarler's avatar
mtarler
Silver Contributor
Jan 02, 2022
=ATAN(A1/B1)*180/PI() + IFS(B1<0,180,A1<0,360,TRUE,0)
  • JimMac's avatar
    JimMac
    Copper Contributor
    Jan 02, 2022
    Thanks for the swift and consise reply. My less than logical mind was taking me down a horribly complicated and convoluted jumble.

    Happy New Year,

    Jim