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(F4TODAY(),F4
_________________
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!!!!