IF Statements

[christal]

Can anyone help me with this problem?
I am trying to put together an "IF" statement which says:

If the due date is< today's date = Late

If the due date is = today's date = Due

If the due date is less 2 days than today's date = AT RISK

Otherwise = Pending

The IF statement I tried to put together, is correct all the way up to "AT RISK". Can anyone tell me how to do 2 days less.

F4 = Due Date
F2 = Today's date

Your help would be greatly appreciated!!

Thanks!
This message was edited by christal on 2002-05-09 11:40

 

[Ricky Morris]

Try:

"=IF(F4<TODAY(),"Late",IF(F4=TODAY(),"Due",IF(AND(F4>TODAY(),F4<TODAY()+3),"At Risk","Pending")))"

_________________
It's never too late to learn something new.

Ricky
This message was edited by Ricky Morris on 2002-05-09 11:47

 

[phillycarol]

Maybe there's a shorter way to do this, but here's one solution:

IF(F4< F2,"Late",IF(F4=F2,"Due",IF(F4=(F2+1),"At Risk",IF(F4=(F2+2),"At Risk","Pending"))))
This message was edited by phillycarol on 2002-05-09 11:48
This message was edited by phillycarol on 2002-05-09 11:49

 

[Mark W.]

=VLOOKUP(F4-TODAY(),{-9E+307,"Late";0,"Due";1,"AT RISK";2,"Pending"},2)

I'm a little uncertain of your "AT RISK" definition. Let me know if I need to refine my formula to fit your needs.
This message was edited by Mark W. on 2002-05-09 12:04

 

[christal]

Philly Carol.....

Thanks! It worked perfect!!!!