Hi,

I'm glad you got the help you needed but remain intrigued as to how you got
a div/0 error with the average formula you posted.

Mike

"June" wrote:

Hello Mike,

Thank you for responding. Max took care of me.
You were a help also with rewriting the original formula.

Thanks
--
June


"Mike H" wrote:

June,

I assume you meant
=AVERAGE(C6,D6,E6,F6,G6,)

which I would re-write as
=AVERAGE(C6:G6)

That formula can't produce a #DIV/0 error, are you sure you posted all your
formula because that comma at the end looks suspicious

Mike

"June" wrote:

Hello,
I've created the following formula:AVERAGE(C6,D6,E6,F6,G6,)
Please help me change this formula to IF function in order to elimnate
#DIV/0! giving me a clean spreadsheet for presentation.
--
June