close

=IF(G12lt;gt;0,G12*F12,quot;quot;) - this formula works fine when the target cell
(g12) has a number in it or is blank. If, though, they have a space or
letter, it gives the #value! What can I add to the formula to keep it
from the #value! result?=IF(AND(G12lt;gt;0,ISNUMBER(G12)),G12*F12,quot;quot;)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;MicroMainquot; gt; wrote in message ups.com...
gt; =IF(G12lt;gt;0,G12*F12,quot;quot;) - this formula works fine when the target cell
gt; (g12) has a number in it or is blank. If, though, they have a space or
gt; letter, it gives the #value! What can I add to the formula to keep it
gt; from the #value! result?
gt;Thanks,

Works great

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

    software

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

    E-mail轉寄