close
=IF(A1 lt; 0,0,IF(A1 gt; 0,A1))
quot;callmewelldolunchquot; wrote:
gt; I need a formula in excel to only output numbers greater than zero and
gt; replace any negative number with zero. The spreadsheet I'm setting up will
gt; be used to controle inventory and when my inventory on an item is greater
gt; than my par for that item it is ordering a negative number of replacements.
gt; the problem is then compounded because the negative number of replacement
gt; items is then used to calculate my future inventory in the spreadsheet.
gt; Thanks.
全站熱搜
留言列表
