I need to hide a formula

[June]

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.

 

[Max]

=IF(ISERROR(AVERAGE(C6:G6)),"",AVERAGE(C6:G6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik

 

[Mike H]

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]

It works.

I just learned that services like this and people like you existed. You were
a great help.

My Boss loves the spreadsheet.

Thank you

 

[Max]

Welcome, June. Happy to receive such feedback. Thanks
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik

 

[June]

Hello Mike,

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

Thanks

 

[Mike H]

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