Formula help
 

I am helping the choir teacher set up a spreadsheet for fundraising and fee
info. Here's my problem. She has imposed a $50 choir fee, which some of the
students have paid (most haven't). She told other students that they could
fundraise the amount if they haven't paid it. I could figure out how to set
that up but my problem is that some of the students made partial payments.
In a nutshell I need a formula that will say...Here's my total fundraising
amount (say $100) from this put $X in my choir fee to equal $50 (some choir
fees might already have the total $50, some might have less than $50, most
have 0), then put the rest in my student account. I had a max/min formula
that would work, except when I got to the kids who had a partial payment in
the field already. I also want to make sure that if the student paid it
already, that payment doesn't get wiped out by my new formula. Any help is
appreciated. I'm a novice at this stuff

Vivian K.

Formula help
 

Enter these labels in Row 1:
A - Name; B - Amt Pre-Paid for Choir Fee; C - Fundraised Amt; D -
Put toward Choir Fee; E - Extra Fundraised Money; F - Choir Fee
Paid

Fill in the data for cols A, B, and C.

Put this in D2:
=IF(B2+C2<50,C2,50-B2)

Put this in E2:
=C2-D2

Put this in F2:
=B2+D2


Fill down.





Viviank Wrote:
I am helping the choir teacher set up a spreadsheet for fundraising and
fee
info. Here's my problem. She has imposed a $50 choir fee, which some
of the
students have paid (most haven't). She told other students that they
could
fundraise the amount if they haven't paid it. I could figure out how
to set
that up but my problem is that some of the students made partial
payments.
In a nutshell I need a formula that will say...Here's my total
fundraising
amount (say $100) from this put $X in my choir fee to equal $50 (some
choir
fees might already have the total $50, some might have less than $50,
most
have 0), then put the rest in my student account. I had a max/min
formula
that would work, except when I got to the kids who had a partial
payment in
the field already. I also want to make sure that if the student paid
it
already, that payment doesn't get wiped out by my new formula. Any
help is
appreciated. I'm a novice at this stuff

Vivian K.


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=477580

Formula help
 

Thanks - that really did the trick. I really appreciate your help.

"Viviank" wrote:

I am helping the choir teacher set up a spreadsheet for fundraising and fee
info. Here's my problem. She has imposed a $50 choir fee, which some of the
students have paid (most haven't). She told other students that they could
fundraise the amount if they haven't paid it. I could figure out how to set
that up but my problem is that some of the students made partial payments.
In a nutshell I need a formula that will say...Here's my total fundraising
amount (say $100) from this put $X in my choir fee to equal $50 (some choir
fees might already have the total $50, some might have less than $50, most
have 0), then put the rest in my student account. I had a max/min formula
that would work, except when I got to the kids who had a partial payment in
the field already. I also want to make sure that if the student paid it
already, that payment doesn't get wiped out by my new formula. Any help is
appreciated. I'm a novice at this stuff

Vivian K.