more formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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)
 
Tom,

I can't find your "previously stated criteria" but perhaps you can read more
into Viviank's posts than I can.

Anyway, given that, surely your formula will produce a negative figure for
the student for a cell value of anything less than $37.50? Unless of course
I am misunderstanding what you mean by "Cell"

--
Regards


Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Perfect! Thanks so much. I'm not very experienced with spreadsheets, I know
just enough to be dangerour. You guys rock.

Vivian
 
Back
Top