Error

  • Thread starter Thread starter Ken Grady
  • Start date Start date
K

Ken Grady

Hi All,
I have a formula that gives the correct result but has an error in the cell
before any data has been entered into the other cells.
Formula: =AVERAGE(F43:G43)
Error: #DIV/0!
How can I eliminate this error please.

Thank you for your assistance.

Ken.
 
Ken, here is one way,
=IF(ISERROR(AVERAGE(F43:G43)),"",AVERAGE(F43:G43))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Another way:

=IF(COUNT(F43:G43)<>0,AVERAGE(F43:G43),"")

Paul, I am fascinated by COUNT() so I try to use COUNT(). If you see a problem, please let me know. Trying to learn here.

Epinn

Ken, here is one way,
=IF(ISERROR(AVERAGE(F43:G43)),"",AVERAGE(F43:G43))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top