Mixing AND & OR functions

[Barney]

Can I mix the AND & OR functions like this.....
=IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0),F11+2,F5)) ???

I can't seem to get it to work. Is there a better way? I tried the another
way using all AND functions but I ended up with more than 7 nested IF
statements. I had 10 nested if and it wouldn't work. In that case there
were more arguements than you see above.

Thanks in advance.

Barney

[Chip Pearson]

Without knowing exactly what you want to do, I can only guess at
the proper formula. Try the following:

=IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0)),F11+2,F5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Barney" <postonbl@yahoo.com> wrote in message
news:d7kpg.10613$Ud4.10246@bignews1.bellsouth.net...
> Can I mix the AND & OR functions like this.....
> =IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0),F11+2,F5)) ???
>
> I can't seem to get it to work. Is there a better way? I
> tried the another way using all AND functions but I ended up
> with more than 7 nested IF statements. I had 10 nested if and
> it wouldn't work. In that case there were more arguements than
> you see above.
>
> Thanks in advance.
>
> Barney
>

[Barney]

Thanks Chip,

That worked just fine.

Barney



"Chip Pearson" <chip@cpearson.com> wrote in message
news:eje3u5KnGHA.2148@TK2MSFTNGP03.phx.gbl...
> Without knowing exactly what you want to do, I can only guess at the
> proper formula. Try the following:
>
> =IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0)),F11+2,F5))
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "Barney" <postonbl@yahoo.com> wrote in message
> news:d7kpg.10613$Ud4.10246@bignews1.bellsouth.net...
>> Can I mix the AND & OR functions like this.....
>> =IF(F5="","",IF(AND($D5<10,OR(F5>(F11+1),F5=0),F11+2,F5)) ???
>>
>> I can't seem to get it to work. Is there a better way? I tried the
>> another way using all AND functions but I ended up with more than 7
>> nested IF statements. I had 10 nested if and it wouldn't work. In that
>> case there were more arguements than you see above.
>>
>> Thanks in advance.
>>
>> Barney
>>
>
>