IF Statement Wont Work

  • Thread starter Thread starter Gazz_85
  • Start date Start date
G

Gazz_85

I have a If statement which loos up a cell for # of days til delivery, and
returns a status. see below:

=IF((OR(I8<=0)),"OVERDUE",(IF((OR(I8<=7)),"EXP THIS
WEEK",(IF((OR(I7>7,I7<=14)),"EXP TWO WEEKS","OVER TWO WEEKS")))))

It works until it gets to the EXP TWO WEEK part, im getting values over 14
saying EXP TWO WEEKS, and no OVER TWO WEEKS values.

Help?????
 
you could just use

=IF(I8<=0,"OVERDUE",IF(I8<=7,"EXP THIS WEEK",IF(I8<=14,"EXP TWO WEEKS","OVER
TWO WEEKS")))
 
You mean..

=IF(I7<=0,"OVERDUE",IF(I7<=7,"EXP THIS WEEK",IF(I7<=14,"EXP TWO WEEKS","OVER
TWO WEEKS")))

OR to handle blank entries in I7

=IF(I7="","",IF(I7<=0,"OVERDUE",IF(I7<=7,"EXP THIS WEEK",IF(I7<=14,"EXP TWO
WEEKS","OVER TWO WEEKS"))))

If this post helps click Yes
 
Back
Top