Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number results to show as zero
I'm creating an inventory order worksheet with predetermined stock levels. As
we update our inventory, these amount are automatically reduced from our predetermined stock levels. The result from the column is either a positive number (# of garments to order) or a negative number (overstock). I'm copying each result to a new cell (so I can know at any given time what quantity to order) and rounding the number to the closest multiple of 10 (have to order in multiples of 10). I'm using the =Mround (G4,10) function. It is working great for all items with a positive number but for the items with a negative number, I'm receiving a #NUM! error. What I'm trying to achieve is if the result is a negative number I want it to display as zero in the new cell. Would appreciate any help with this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number results to show as zero
How about:
=If(G4<0,0,Mround(G4,10)) Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca Soccer Guy wrote: I'm creating an inventory order worksheet with predetermined stock levels. As we update our inventory, these amount are automatically reduced from our predetermined stock levels. The result from the column is either a positive number (# of garments to order) or a negative number (overstock). I'm copying each result to a new cell (so I can know at any given time what quantity to order) and rounding the number to the closest multiple of 10 (have to order in multiples of 10). I'm using the =Mround (G4,10) function. It is working great for all items with a positive number but for the items with a negative number, I'm receiving a #NUM! error. What I'm trying to achieve is if the result is a negative number I want it to display as zero in the new cell. Would appreciate any help with this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative number results to show as zero
Thank you Ken. Works prefectly. Really appreicate it.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display negative results | Excel Worksheet Functions | |||
Force function to show positive or negative number? | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
MROUND on a negative number. | Excel Discussion (Misc queries) | |||
abdualmohsn | Excel Discussion (Misc queries) |