Joel:

This solution you suggested:

Try lookup instead

=lookup((C10+B26),{-180,180,360;C10+B26+360,C10+B26,C10+B26-360})


does NOT seem to work, as my EXCEL does not recognize the C10+B26 as part of
the array...any explanations?

Thanks,

FLKulchar

"Joel" wrote in message
...
Try lookup instead

=lookup((C10+B26),{-180,180,360;C10+B26+360,C10+B26,C10+B26-360})

"F. Lawrence Kulchar" wrote:

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