HERE IS THE CORRECTED nested "IF" FUNCTION ANSWER:

=IF((C10+B26)=180,C10+B26-360,IF((C10+B26)<=-180,C10+B26+360,C10+B26))

THERE WE GO..IT WORKS:

As to the LOOKUP function, I do NOT comprehend it, i.e. I cannot get it to
work!


Thanks,

FLKulchar


"F. Lawrence Kulchar" wrote in
message ...
I have this formula typed into a cell:

=IF((C10+B26)180,C10+B26-360,C10+B26)

AND...it works fine; however, I have to add the following parameter to the
same cell:

= IF((C10+B26)<180,C10+B26+360,C10+B26)

Please notice the subtle differences..I am working with a global 360
degree
sphere wherein when values are combined, I can be maxed at positive
(+179.999) degrees or minimized at negative (-179.999) degrees.

I tried the "OR" function outside my "IF" function, but all I got was
"TRUE"
for the answer..not an actual number.

PLEASE OFFER THE CORRECT FORMULA.

Thank you,

FLKulchar