| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I replace negative numbers with zero in Excel.
I need a formula in excel to only output numbers greater than zero and
replace any negative number with zero. The spreadsheet I'm setting up will be used to controle inventory and when my inventory on an item is greater than my par for that item it is ordering a negative number of replacements. the problem is then compounded because the negative number of replacement items is then used to calculate my future inventory in the spreadsheet. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace negative numbers with zero in Excel. | Excel Worksheet Functions | |||
| negative numbers in parenthesis are not clear on excel printout? | Excel Discussion (Misc queries) | |||
| Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
| How do I make all numbers in a column negative in excel 2000? | Excel Discussion (Misc queries) | |||
Threaded Mode
