If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Sumif"or "if" ...followup question
Thanx, Paul, that worked! But I have another question. If
I get a "NO" and enter that in the RSVP column, can I get the "balance due" to blank out? -----Original Message----- Peter, Here is one way, with deposit in A2, additional payments in B2 and guest in C2, put this in D2 =IF(ISBLANK(C2),300-A2-B2,400-A2-B2) -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Peter" wrote in message ... I am holding a function where if the person comes alone, the price is $300, but if he brings his wife, the price is $400. I am collecting deposits, and will accept partial payments until the due date. In my spreadsheet, I have two columns, one showing the initial deposit, and another for additional payments. How do I get the balance due to show up in the last column of my spreadsheet? I thought that is a guest's name was intered in the "guest" column, I could write an "IF" statement to make the balance due to be $400 minus the deposit minus the additional payments. But I am not sure how to write this statement. |
#2
|
|||
|
|||
"Sumif"or "if" ...followup question
Hi Peter,
You can change the "Balance Due" formula to something like this: (Assuming Column E is where the RSVP is) =IF(E2="NO","",IF(ISBLANK(C2),300-A2-B2,400-A2-B2)) Hope that helps. Regards, James S -----Original Message----- Thanx, Paul, that worked! But I have another question. If I get a "NO" and enter that in the RSVP column, can I get the "balance due" to blank out? -----Original Message----- Peter, Here is one way, with deposit in A2, additional payments in B2 and guest in C2, put this in D2 =IF(ISBLANK(C2),300-A2-B2,400-A2-B2) -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Peter" wrote in message ... I am holding a function where if the person comes alone, the price is $300, but if he brings his wife, the price is $400. I am collecting deposits, and will accept partial payments until the due date. In my spreadsheet, I have two columns, one showing the initial deposit, and another for additional payments. How do I get the balance due to show up in the last column of my spreadsheet? I thought that is a guest's name was intered in the "guest" column, I could write an "IF" statement to make the balance due to be $400 minus the deposit minus the additional payments. But I am not sure how to write this statement. |
Thread Tools | |
Display Modes | |
|
|