close
When using an IF function, how do you eliminate the #VALUE when you try to
subtract one cell from another cell. The #VALUE sign appears in the cell with
the formula.
It's because one or more cells in a calculation are text and not numbers or
blanks like quot;quot; or quot; quot;
=IF(ISTEXT(A2),0,B2-A2)
--
Regards,
Peo Sjoblom
Portland, Oregon
quot;Ryanquot; gt; wrote in message
...
gt; When using an IF function, how do you eliminate the #VALUE when you try to
gt; subtract one cell from another cell. The #VALUE sign appears in the cell
gt; with
gt; the formula.
全站熱搜
留言列表
