I want to display a blank cell when my formula returns div/0!

[rb_sf]

Hi,

I have a column with a formula in it. there are several rows that have
no data. The formula displays a result of #DIV/0! on all the rows with
blank cells.

How do I get Excel to display these cells as blank? Also, where would I
find this info? What should I have asked the Office Assistant? I'd
guess the answer is in there- somewhere....

thanks in advance

I am using Excel X for Mac

 

[BAC]

To avoid things like #DIV/0 in unneeded cells, I always just wrap an if
statement around the desired formula:
e.g. in cell D6, the formula =IF(ISNUMBER(C6),B6/C6,"") will be blank if
there isn't a value in C6.

 

[rb_sf]

thanks,
It worked perfectly- I knew there'd be an easy answer.

RB