hopefully easy one to answer !!
 

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

hopefully easy one to answer !!
 

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


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=545796

hopefully easy one to answer !!
 

Hi Paul,

One way:

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

---
Regards,
Norman


"Paul Cooke" wrote
in message ...

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

hopefully easy one to answer !!
 

Many thanks Richard - works perfectly :)

Thanks again

Pau

--
Paul Cook
-----------------------------------------------------------------------
Paul Cooke's Profile: http://www.excelforum.com/member.php...fo&userid=2926
View this thread: http://www.excelforum.com/showthread.php?threadid=54579

hopefully easy one to answer !!
 

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

will do it for you