If sum

[Debsdad]

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

 

[Mike Rogers]

Debsdad

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

Mike Rogers

 

[PCLIVE]

Try this:

=IF(C4<D4,C4-D4,0)

HTH,
Paul

 

[Debsdad]

Thanks mike this worked!

Debsdad

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

Mike Rogers

 

[Mike Rogers]

Debsdad

Glad you got it sorted out!! You had most of the answer in you post. You
could have figured it out, you were almost there. Keep working at it and
things do start to make sense. Thanks for the post back.

Mike Rogers

 

[David Biddulph]

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

Debsdad

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

Mike Rogers