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