I need to hide a formula

  • Thread starter Thread starter June
  • Start date Start date
J

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.
 
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
 
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
 
Hello Mike,

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

Thanks
 
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
 
Back
Top