If sum
 

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

If sum
 

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

If sum
 

Try this:

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

HTH,
Paul

--

"Debsdad" wrote in message
...
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

If sum
 

Thanks mike this worked!

"Mike Rogers" wrote:

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

If sum
 

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

"Debsdad" wrote:

Thanks mike this worked!

"Mike Rogers" wrote:

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

If sum
 

.... 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