| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I replace negative numbers with zero in Excel.
=IF(A1 < 0,0,IF(A1 0,A1))
"callmewelldolunch" wrote: 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 | |||
| 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) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Threaded Mode
