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?

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

Try this:

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=523724

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

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?

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

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?

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

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