close
How can I replace the result quot;#VALUE!quot; where it occurs in a worksheet with
quot;N/Aquot;
or else how can I have the cell to the right of any cell bearing N/A also
display N/A?
Hi!
#VALUE! is the result from a formula. Try this:
=IF(ISERROR(your_formula_here)),quot;N/Aquot;,your_formula_here))
Biff
quot;Peterpunkinquot; gt; wrote in message
...
gt; How can I replace the result quot;#VALUE!quot; where it occurs in a worksheet with
gt; quot;N/Aquot;
gt; or else how can I have the cell to the right of any cell bearing N/A also
gt; display N/A?
全站熱搜
留言列表
