Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number < 0 = 0
I am trying to conduct inventory of hardware. I need to know based on what i
have, what i need to order. When i place the needed qty, and subtract the instock qty, sometimes i receive a neg. number. What formula do i use, so that instead of a neg. number, it automatically shows up as a "0"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number < 0 = 0
maybe...
=max(0,youroriginalformulahere) yaypalmtrees wrote: I am trying to conduct inventory of hardware. I need to know based on what i have, what i need to order. When i place the needed qty, and subtract the instock qty, sometimes i receive a neg. number. What formula do i use, so that instead of a neg. number, it automatically shows up as a "0"? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number < 0 = 0
Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1 In D11 use this =If(C1<=0,0,C1) -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=524547 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number < 0 = 0
Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1 In D1 use this =If(C1<=0,0,C1) or make C1 this formula =If(A1-B1<=0,0,A1-B1) -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=524547 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number < 0 = 0
Thank you so much. =If(A1-B1<=0,0,A1-B1) did exactly what i needed it to do.
"intruder9" wrote: Supose A1 was Instock, B1 was Needed and C1 was your answer of A1-B1 In D1 use this =If(C1<=0,0,C1) or make C1 this formula =If(A1-B1<=0,0,A1-B1) -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=524547 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |