IF and OR functions
I have figured it out on my own...simply, I "nested" the 'IF' functions.
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
|