.... or =MIN(C4-D4,0)
--
David Biddulph

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Debsdad

If I understand correctly: =IF(C4<D4,C4-D4,0)

Mike Rogers

"Debsdad" wrote:

I have a spread sheet that has a safety stock quantity(Colum D4) and a
quantity on handColum C4). I would like to have the next colum (E4)
state: if
quantity on hand is less than D4 then = C4-D4, but if C4 is equal or
greater
than D4 then return with 0.
Thank you