"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.

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.

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.



.

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?

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.



.