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