Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |