Hi,
How can i remove this error: #DIV/0!
thanks
Hi,
How can i remove this error: #DIV/0!
thanks
Don't divide by zero
=IF(A2=0,0,B2/A2)
Regards, tms
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Not much to go on. What is the formula that is producing the error?
TMS - My first thought was to hit the delete key!
thanks. its "=AVERAGE(B6:V6)" when it has empty values
Use either of the below
1) =iferror(average(B6:V6),0)
2) =if(count(B6:V6)=0,0,average(B6:V6))
Life's a spreadsheet, Excel!
Say thanks, Click *
Cancel the IFERROR() suggestion - Excel 2003 doesn't recognize it.
but with a formula how do i do it? thanks
Here's another way:
=IF(SUM(B6:V6),AVERAGE(B6:V6),0)
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
thanks its solved
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks