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
|
|||
|
|||
"If" or "sumif"
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
|
|||
|
|||
"If" or "sumif"
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. |
#3
|
|||
|
|||
"If" or "sumif"
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. . |
#4
|
|||
|
|||
"If" or "Sumif"
Thanx, Paul, that worked! But I have another question. If
I get an RSVP as "NO" and enter that in the RSVP column, can I get the "balance due" to blank out? |
#5
|
|||
|
|||
"If" or "sumif"
If your RSVP column is E, then adding to Paul's in column D
=IF(E2="NO","",ISBLANK(C2),300-A2-B2,400-A2-B2) Ken "Peter" wrote in 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 | |
|
|