Thread: 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

=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

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

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" <Viviank@discussions.microsoft.com> wrote in message
news:4AAC4AE5-6996-4788-93F6-61E91794450F@microsoft.com...
> 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

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
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk


"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eQIA6eQyFHA.1032@TK2MSFTNGP12.phx.gbl...
> 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" <Viviank@discussions.microsoft.com> wrote in message
> news:4AAC4AE5-6996-4788-93F6-61E91794450F@microsoft.com...
>> 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
>
>

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