close

I know how to do this in an Access query... I just don't want to take my list
of data over there and bring it back to Excel. Is there a function that can
do something like an IF statement:

=IF(IsNull(A1), A1, 0)

Nevermind... IsBlank() worked fine.

quot;Ericquot; wrote:

gt; I know how to do this in an Access query... I just don't want to take my list
gt; of data over there and bring it back to Excel. Is there a function that can
gt; do something like an IF statement:
gt;
gt; =IF(IsNull(A1), A1, 0)

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

    software

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

    E-mail轉寄