#DIV/0 error

[Byron]

I'm trying to find the average of a range of cells and have the following
formula =average(D3:N3). I keep getting the following message #DIV/0!. The
formula works and the error goes away once I start entering information into
the cells. The cells do not have a value untill I enter it. I tried using anf
IF function =IF(average(D3:N3)=0,0,average(D3:N3)) but I still get the same
result.

Thanks in advance for any assistance you can provide me

 

[Charles Williams]

One way would be to use a formula like this:

=IF(ISERROR(AVERAGE(D3:N3)),0,AVERAGE(D3:N3))

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Byron]

I tried your formula and it worked. Thanks for your assistance

 

[Vitordf]

Hi,

Try using the ISERROR statment;

=IF(ISERROR(AVERAGE(D3:N3)),0,AVERAGE(D3:N3)).

Hope this helps,

Regs,