average & iserror formula

  • Thread starter Thread starter Derrell Teat
  • Start date Start date
D

Derrell Teat

Example:
Have a column (e1:e9) that is totaled in cell e10
Cell e11 is a average of e1:e9
But if no numbers it returns a error, so how do I have e11 return
0.0?
I think it is a nested formula with the iserror..but I cant figure ou
how..help please,
Thanks,
Derrel
 
Thanks Ken!! The help I have received in the past from you & others i
greatly appreciated
 
You're welcome, and many thanks for the feedback - always much appreciated by
all.
 
Back
Top