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.

How do I replace negative numbers with zero in Excel.
 

Here is a quick sample:
The following is entered in an empty Cell or Column - I used Column B
for the following formula - the value you want to evaluate is in Cell
A2.
=IF(A20,A2,0)
Read as: if A2 is greater than 0, then I want the value of A2 in cell
B2 - If the value is 0 or less than 0, (i.e. -1) then the value is 0.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=523286