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

 

[RichardSchollar]

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

 

[Norman Jones]

Hi Paul,

One way:

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

 

[Paul Cooke]

Many thanks Richard - works perfectly

Thanks again

Pau

 

[aidan.heritage]

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

will do it for you