Alright - this is driving me nuts and I have gotten it to work in other applications with other configurations.
The formula below is not producing the desired results. All that is displaying is either "Send 3rd" or "Current"
=IF(E562<($Q$2+10), "Send 3rd",IF(E562<($Q$2-4),"Send 2nd",IF(E562<($Q$2-13),"Send 1st",IF(E562> ($Q$2+10),"Current","Check"))))
Cell E562 in this case is a date of a tasks last completion
Cell $Q$2 contains the funciton =TODAY()
Essentially I'm trying to evaluate the date of the tasks last completion against today's date. Based on that evaluation it should display one of the following options "Send 3rd", "Send 2nd", "Send 1st", or "Current". I'm only getting "Send 3rd" or "Current".
I'm hoping a second set of eyes on this will help. Thanks for all your help.
2007-02-28 03:32:35 · 1 answers · asked by jaruby05 1 in Computers & Internet ➔ Software
If the value is NOT less than $Q$2+10, then logically it cannot be less than $Q$2-4 or $Q$2-13 either - those cases could never occur.
Put the check for "Send 1st" first, then the "Send 2nd" and then the "Send 3rd"
2007-02-28 03:50:06 · answer #1 · answered by BigRez 6 · 0⤊ 0⤋