combining 3 if statements into one
Results 1 to 4 of 4

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

  1. #1
    New Member
    Join Date
    Feb 2015
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default combining 3 if statements into one

    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
    Last edited by amritkishan29; Feb 25th, 2015 at 03:42 AM.

  2. #2
    Board Regular
    Join Date
    Apr 2004
    Posts
    7,895
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: combining 3 if statements into one

    =if(k13=today()+3,"Billing Due",if(n13="Paid","",if(n13="Not Paid","Billing Due","")))
    Yesterday I felt on top of the world. Today its falling in on me.

  3. #3
    New Member
    Join Date
    Feb 2015
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #4
    New Member
    Join Date
    Feb 2015
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: combining 3 if statements into one

    Quote Originally Posted by SteveO59L View Post
    =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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •