Provide 3 different results based upon date differences

[InterstateRentals]

One more problem that we cannot get figured out ... Example file is attached.


We have a table with dates A7:A16. We want to compare this list of dates to a date that we input in A1.


Three different results that we want ...

Case 1: ($A$1-$A7)<=15, then $B7="GOOD"

Case 2: 15<($A$1-$A7)<30, then $B7="CALL"

Case 3: ($A$1-$A7)>30, then $B7="CALL!!!"


The results that we expect to get in Column B are written in Column E.

Thank you!

[judgeh59]

try this

=IF($A$1-A7<=15,"GOOD",IF(AND($A$1-A7>15,$A$1-A7<30),"CALL","CALL!!!!"))

[InterstateRentals]

Judgeh59, that is exactly what we were looking for!! AWESOME!!!

Thank you for the great solution!!!

[judgeh59]

glad I could help...have a great day and thanks for the points....

[benishiryo]

hi there. leveraging on Ernest's formula, you could reduce it to:
=IF($A$1-A7<=15,"GOOD",IF($A$1-A7<30,"CALL","CALL!!!!"))

because the 1st test has been done to check for those lesser or equals to 15, you are automatically checking for above 15 in the next test, so there's no need for:
$A$1-A7>15

do remember to mark the thread "Solved" as well. thanks