AAArgh, can I display a blank cell if the formula value doesn't co

[Matt]

I could probably find the answer to this question if I only new the right
terms to search by. My problem is I have a sheet where I have values in
cells b3 through m3. I then average those values in cell n3. I have
multiple(many) rows so I dragged this formula down to the bottom. The
problem is that for any rows where I don't have data in the b through m cells
the cell(n3) displays #DIV/0!. Is there a way to write the formula so that
it will be blank unless data is entered into b3 through m3? This is really
only a cosmetic issue as I could easily delete those formulas where I don't
yet have data and drag them in when I do but that isn't the most elegant
solution.

Any help?

 

[Cutter]

Try this:

=IF(ISERR(your formula),"",your formula

 

[Elkar]

Try this:

=IF(ISERROR(formula),"",formula)

Replace the word formula with whatever formula you're currently using.

HTH,
Elkar

 

[Matt]

Thanks to both of you that worked.

Try this:

=IF(ISERROR(formula),"",formula)

Replace the word formula with whatever formula you're currently using.

HTH,
Elkar

 

[Dave Peterson]

Another way is to look at the quantity of numbers in that range:

=if(count(b3:m3)=0,"No numbers",average(b3:m3))