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

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

    software

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

    E-mail轉寄