close

I am facing problems with cell that has not been fill. In cell C1 there is a
formula that reference to B1. But before B1 is fill, C1 will displayed.

In C1, enter:
=IF(B1=quot;quot;,quot;quot;,Your_formula)

HTH
--
AP

quot;chiuinggumquot; gt; a écrit dans le message
de ...
gt; I am facing problems with cell that has not been fill. In cell C1 there is
a
gt; formula that reference to B1. But before B1 is fill, C1 will displayed.

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

    software

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