# Thread: combining 3 if statements into one Thanks: 0 Likes: 0

1. ## combining 3 if statements into one

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

2. ## Re: combining 3 if statements into one

=if(k13=today()+3,"Billing Due",if(n13="Paid","",if(n13="Not Paid","Billing Due","")))

3. ## Re: combining 3 if statements into one

that works man, thanks! :D but i need another little help..i need it to say "Billing due" if the paid/not paid cell is empty when its due time to pay! what should i do for that?

4. ## Re: combining 3 if statements into one

Originally Posted by SteveO59L
=if(k13=today()+3,"Billing Due",if(n13="Paid","",if(n13="Not Paid","Billing Due","")))
if i put this formula, the first part where the date is compared to the current date isn't working