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
 

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

Multiple If Stmts 2
multiple if conditions - use sumif/sumProduct? 3
MessageSecurityException problem in WCF 4
Formula to return Vacation weeks 1
Nesting if/or/and 4
Failing IF Statement 2
Excel Worksheet_BeforeDelete code not working as expected. 1
Which 2 in 1 or laptop for 6 year old ? 8

Back
Top