close

I'm trying to copy(downward) a formula but I want it to leave blank cells
blank. It's gining it a value of 0 currently. Here's the formula I want
copied skipping blank cells.
=IF( E8=0,0, F8/E8)

Try =IF(ISBLANK(E8),quot;quot;,IF(E8=0,0,F9/E8))
or =IF(E8=quot;quot;,quot;quot;,IF(E8=0,0,E9/F8))
This is called 'nesting' of IFs
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Annquot; gt; wrote in message
...
gt; I'm trying to copy(downward) a formula but I want it to leave blank cells
gt; blank. It's gining it a value of 0 currently. Here's the formula I want
gt; copied skipping blank cells.
gt; =IF( E8=0,0, F8/E8)

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

    software

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

    E-mail轉寄