Div/0

[dmay1102]

Hey, I am trying to take an average of a series of numbers, but if there are no numbers there then I just want the cell blank. I thought this formula would get rid of the #DIV/0! message but it didn't.

=IF(ISBLANK(F58&F62&F66&F70&F74&F78&F82&F86&F90&F94&F98&F102),"",AVERAGE(F58,F62,F66,F70,F74,F78,F82,F86,F90,F94,F98,F102))

Can anyone firgure out what I'm trying to do?
Thanks,
Dave

[shg]

You can do

=if(iserror(average(...)), "", average(...))

... or, if you have Excel 2007,

=iferror(average(...), "")

... or, you can use conditional formatting to hide the error.