Mixing AND & OR functions

  • Thread starter Thread starter Barney
  • Start date Start date
B

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
 
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
 
Thanks Chip,

That worked just fine.

Barney



Chip Pearson said:
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
Click to expand...
 
Back
Top