popup message not deactivated

[shaniwafa]

Hi, I am maintaining a monthly utility schedule with column D5 to show the last date to pay bill, column E5 for the amount (which is linked from a particular utility account), and column F5 for messages to popup on at regular intervals according to the approach of maturity date. But, even when the amount column E5 shows zero after the bill being settled, the message is still active. If the amount column shows less than 1, preferably no message should appear in F5, till new bill gets entered in the particular utility account. How can this be rectified? Your response will be highly appreciated.

Formula currently being used:

IF(D5<=TODAY(),"MES -1",IF(D5< today()+2,"mes-2",if(D5< today()+6,"mes-3","")))

 

[AlphaFrog]

Wrap your formula in another IF function to test the E5 Value...
=IF(E5<1,"",IF(D5<=TODAY(),"MES -1",IF(D5< TODAY()+2,"mes-2",IF(D5< TODAY()+6,"mes-3",""))))

 

[shaniwafa]

Thanks for your answer. A new formula I could learn through your wonderful suggestion. Thanks.
I wish to add one more condition, same like date column to consider?