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]

Thanks Chip,

That worked just fine.

Barney

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