IF Statement Wont Work

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?????
 
K

Kevin Smith

you could just use

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

Jacob Skaria

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
 
Top