close
Formula in cell =(B5-A5) I want to check if result is negative and if so
replace result with 0
So this cell will either be a positive number or zero.
=MAX(0,(B5-A5))
Vaya con Dios,
Chuck, CABGx3
quot;Richquot; wrote:
gt; Formula in cell =(B5-A5) I want to check if result is negative and if so
gt; replace result with 0
gt;
gt; So this cell will either be a positive number or zero.
gt;
gt;
=MAX(B5-A5,0)
--
HTH
RP
quot;Richquot; gt; wrote in message
...
gt; Formula in cell =(B5-A5) I want to check if result is negative and if so
gt; replace result with 0
gt;
gt; So this cell will either be a positive number or zero.
gt;
gt;
全站熱搜
留言列表
