hopefully easy one to answer !!

[Paul Cooke]

I have 6 sheets on a spread sheet with sheet 1 being a "master" and referenceing sheets 2,3,4,5 & 6

At the moment cell "P3" shows the total number of items that need to be ordered and is coded as follows:

=D3*5-E3-G3-I3-K3-M3-O3

on some of the items in "P3" it shows a minus value (as we already have some in stock) is there a way to code this to show zero when the sum equals a minus value

Hopefully this is explained well and would appriciate any help that you can offer

Many thanks

Paul

[Richard Schollar]

Paul

You can use a simple IF formula:

=IF((D3*5-E3-G3-I3-K3-M3-O3)<0,0,D3*5-E3-G3-I3-K3-M3-O3)

in cell P3.

Hope this helps!

Richard

[Paul Cooke]

Many thanks Richard - works perfectly

Thanks again

Paul

[Norman Jones]

Hi Paul,

One way:

=MAX(D3*5-E3-G3-I3-K3-M3-O3, 0)

---
Regards,
Norman


"Paul Cooke" <[email protected]> wrote
in message news:[email protected]...
>
> I have 6 sheets on a spread sheet with sheet 1 being a "master" and
> referenceing sheets 2,3,4,5 & 6
>
> At the moment cell "P3" shows the total number of items that need to be
> ordered and is coded as follows:
>
> =D3*5-E3-G3-I3-K3-M3-O3
>
> on some of the items in "P3" it shows a minus value (as we already have
> some in stock) is there a way to code this to show zero when the sum
> equals a minus value
>
> Hopefully this is explained well and would appriciate any help that you
> can offer
>
> Many thanks
>
> Paul
>
>
> --
> Paul Cooke
> ------------------------------------------------------------------------
> Paul Cooke's Profile:
> http://www.excelforum.com/member.php...o&userid=29268
> View this thread: http://www.excelforum.com/showthread...hreadid=545796
>

[[email protected]]

=max(0,D3*5-E3-G3-I3-K3-M3-O3 )

will do it for you