amritkishan29
New Member
- Joined
- Feb 25, 2015
- Messages
- 3
please help me..
i programmed cell k13 to remind me "billing due" if i have paid my bills or not using today() function..if we paid, we need to type "paid" into n13 and it should clear the text in k 13..if we haven't yet paid we need to type "not paid" and it should say "Billing due"
these are my three formulas..but they aren't clearing the cell..=IF(K13 *less than TODAY()+3,"BILLING DUE","")&IF(N13="PAID","","")&IF(N13="NOT PAID","BILLING DUE","")
*the less than symbol deletes my texts after the symbol in this thread for no reason so thats why i've typed it in
thanks
i programmed cell k13 to remind me "billing due" if i have paid my bills or not using today() function..if we paid, we need to type "paid" into n13 and it should clear the text in k 13..if we haven't yet paid we need to type "not paid" and it should say "Billing due"
these are my three formulas..but they aren't clearing the cell..=IF(K13 *less than TODAY()+3,"BILLING DUE","")&IF(N13="PAID","","")&IF(N13="NOT PAID","BILLING DUE","")
*the less than symbol deletes my texts after the symbol in this thread for no reason so thats why i've typed it in
thanks
Last edited: