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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for transferring data in rows to columns on two different Worksheets 1
Create a learning tool with Excel 0
Double Lookup 5
Formula to predict future data 1
Formula to return Vacation weeks 1
Receiving unexpected Duration 0
identifying the next working day after weekends and/or holidays 2
Adding values generated by "IF" Statement 3

Top