Nested if sums

[Notters]

Hi all, i should know this but i'm having a mare..

what i need to do is show the following

If the date in A4 is the same as the date in A1 i need it to say Due today
If the date in A4 is 5 days or more before the date in A1 i need it to say due
If the date in A4 is 3 day before the date in A1 i need it to say Due soon
If the date in A4 is after the date in A1 i need it to say late

Thnak you

[meyero90]

try this

=IF($A$4=A1,"Due Today",IF($A$4>=A1+5,"Due",IF($A$4<=A1-3,"Due Soon",IF($A$4>A1,"Late"))))

hope this helps

[meyero90]

Apologies here's the correct answer

=IF(A4=$A$1,"Due Today",IF(A4>=$A$1+5,"Due",IF(A4<=$A$1-3,"Due Soon",IF(A4>$A$1,"Late"))))

[meyero90]

Correct answer is in post #3

[DonkeyOte]

meyero90 - I don't think that returns the correct results.

Another alternative perhaps:

=LOOKUP(A4-A$1,{-9.99E+307,-3,0,1},{"Due","Due soon","Due Today","Late"})

[Marcol]

Not so elegant but perhaps a bit more informative
[

Please Login or Register  to view this content.

ROUNDDOWN is used in case A4 =Now()

Hope this helps