IF and OR functions

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

FLKulchar
Fri May 09 07:24:20 CDT 2008

I have figured it out on my own...simply, I "nested" the 'IF' functions.

Thanks,

FLKulchar
"F. Lawrence Kulchar" <FLawrenceKulchar@discussions.microsoft.com> wrote in
message news:CBAD7474-85B8-46B4-94A7-04C2E6DFDD7F@microsoft.com...
>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

Joel
Fri May 09 07:29:01 CDT 2008

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

FLKulchar
Fri May 09 08:21:57 CDT 2008

Joel:

I cannot get your array "lookup" formula to work -- I get an error message
with the C10 +B26+360 bit of info.

Please explain please!

Thanks,

FLKulchar
"Joel" <Joel@discussions.microsoft.com> wrote in message
news:F443F8CA-A436-47EC-90E5-EF5AD579C3D4@microsoft.com...
> 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

FLKulchar
Fri May 09 08:58:01 CDT 2008

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" <FLawrenceKulchar@discussions.microsoft.com> wrote in
message news:CBAD7474-85B8-46B4-94A7-04C2E6DFDD7F@microsoft.com...
>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

FLKulchar
Sun May 11 14:43:41 CDT 2008

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" <Joel@discussions.microsoft.com> wrote in message
news:F443F8CA-A436-47EC-90E5-EF5AD579C3D4@microsoft.com...
> 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