close

If excel returns #N/A due to information not being found for formula, can it
be changed to No

try
=if(isna(yourformula),quot;NOquot;,yourformula)

--
Don Guillett
SalesAid Software

quot;Freddoquot; gt; wrote in message
...
gt; If excel returns #N/A due to information not being found for formula, can
gt; it
gt; be changed to No

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()