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

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?

Try this:

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

Try this:

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

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

HTH,
Elkar


"Matt" wrote:

> 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?

Thanks to both of you that worked.

"Elkar" wrote:

> Try this:
>
> =IF(ISERROR(formula),"",formula)
>
> Replace the word formula with whatever formula you're currently using.
>
> HTH,
> Elkar
>
>
> "Matt" wrote:
>
> > 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?

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

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





Matt wrote:
>
> 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?

--

Dave Peterson