| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
