#div/0!

**devilonline** · 07-08-2012, 02:45 PM

Hi,

How can i remove this error: #DIV/0!

thanks

**TMS** · 07-08-2012, 02:48 PM

Don't divide by zero

=IF(A2=0,0,B2/A2)

Regards, tms

**Cutter** · 07-08-2012, 02:48 PM

Not much to go on. What is the formula that is producing the error?

TMS - My first thought was to hit the delete key!

**devilonline** · 07-08-2012, 03:01 PM

thanks. its "=AVERAGE(B6:V6)" when it has empty values

**Ace_XL** · 07-08-2012, 03:03 PM

Use either of the below

1) =iferror(average(B6:V6),0)
2) =if(count(B6:V6)=0,0,average(B6:V6))

**Cutter** · 07-08-2012, 03:07 PM

Cancel the IFERROR() suggestion - Excel 2003 doesn't recognize it.

**devilonline** · 07-08-2012, 03:31 PM

but with a formula how do i do it? thanks

**xladept** · 07-08-2012, 05:02 PM

Here's another way:

Please Login or Register  to view this content.

**devilonline** · 07-08-2012, 05:34 PM

thanks its solved

**xladept** · 07-08-2012, 07:48 PM

You're welcome!

Re: #div/0!