#DIV/0! Error Formula Help

lhk201

New Member
Joined
Feb 27, 2011
Messages
35
Hello everyone,

I am using the following formula for a number of cells

=AVERAGE(a2:a99)

Some results come back #DIV/0! but because I am using the figures for a chart I would like the result to show blank if this is the case.

Is there an IF formula that can help me with this maybe?

Thanks in advance!!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,276
Office Version
  1. 2013
Platform
  1. Windows
try
Code:
=IF(ISERROR(AVERAGE(A2:A99)),"",AVERAGE(A2:A99))
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
Hello everyone,

I am using the following formula for a number of cells

=AVERAGE(a2:a99)

Some results come back #DIV/0! but because I am using the figures for a chart I would like the result to show blank if this is the case.

Is there an IF formula that can help me with this maybe?

Thanks in advance!!

On Excel 2007 or later...

=IFERROR(AVERAGE(A2:A99),"")

Otherwise, something like:

=IF(COUNT(A2:A9),AVERAGE(A2:A99),"")
 

lhk201

New Member
Joined
Feb 27, 2011
Messages
35
Thanks everyone for their speedy response, I used Micheal's formula and it work just fine! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,447
Messages
5,528,803
Members
409,837
Latest member
karnasrinivas
Top