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

"Ken Grady" wrote in message
...
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.