Home |
Search |
Today's Posts |
#1
|
|||
|
|||
more formula help
Once again working on the fundraiser spreadsheet... Teacher wants ... of
total money raised, 40% is profit...of that profit the first $15 goes to the general account, the difference goes in the student account. The only thing I really need to keep track of is the student account, which I figured would be (cell*.4)-15, but the problem I have is ... If the child raised zero dollars, it's showing a -$15 dollar balance, but I would need it to show zero. Any help is appreciated. Vivian K |
#2
|
|||
|
|||
=MAX(yourexpression,0)
-- Gary''s Student "Viviank" wrote: Once again working on the fundraiser spreadsheet... Teacher wants ... of total money raised, 40% is profit...of that profit the first $15 goes to the general account, the difference goes in the student account. The only thing I really need to keep track of is the student account, which I figured would be (cell*.4)-15, but the problem I have is ... If the child raised zero dollars, it's showing a -$15 dollar balance, but I would need it to show zero. Any help is appreciated. Vivian K |
#3
|
|||
|
|||
Assume the amount raised is in Col A, the general account in Col B, and the
student account in Col C. For row 2, the general account formula in B2 is =min(15,.4*A2) the student account formula in C2 is =.4*A2-B2 or, if you want to dispense with the general account column =Max(0,.4*A2-15) "Viviank" wrote: Once again working on the fundraiser spreadsheet... Teacher wants ... of total money raised, 40% is profit...of that profit the first $15 goes to the general account, the difference goes in the student account. The only thing I really need to keep track of is the student account, which I figured would be (cell*.4)-15, but the problem I have is ... If the child raised zero dollars, it's showing a -$15 dollar balance, but I would need it to show zero. Any help is appreciated. Vivian K |
#4
|
|||
|
|||
Based on your previously stated criteria, the only way a student would have
less than $15 is if they sold zero. You can easily check if that is the case =if(qtysold=0,0,Cell*.4-15) -- Regards, Tom Ogilvy "Viviank" wrote in message ... Once again working on the fundraiser spreadsheet... Teacher wants ... of total money raised, 40% is profit...of that profit the first $15 goes to the general account, the difference goes in the student account. The only thing I really need to keep track of is the student account, which I figured would be (cell*.4)-15, but the problem I have is ... If the child raised zero dollars, it's showing a -$15 dollar balance, but I would need it to show zero. Any help is appreciated. Vivian K |
#6
|
|||
|
|||
Perfect! Thanks so much. I'm not very experienced with spreadsheets, I know
just enough to be dangerour. You guys rock. Vivian "Duke Carey" wrote: Assume the amount raised is in Col A, the general account in Col B, and the student account in Col C. For row 2, the general account formula in B2 is =min(15,.4*A2) the student account formula in C2 is =.4*A2-B2 or, if you want to dispense with the general account column =Max(0,.4*A2-15) "Viviank" wrote: Once again working on the fundraiser spreadsheet... Teacher wants ... of total money raised, 40% is profit...of that profit the first $15 goes to the general account, the difference goes in the student account. The only thing I really need to keep track of is the student account, which I figured would be (cell*.4)-15, but the problem I have is ... If the child raised zero dollars, it's showing a -$15 dollar balance, but I would need it to show zero. Any help is appreciated. 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) |