View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FLKulchar FLKulchar is offline
external usenet poster
 
Posts: 80
Default 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