P
Preschool Mike
I'm using the AVERAGE formula to return the average of cell X9:BB9 but get
the #DIV/0! error message when the cell are empty. How can I eliminate this
message? I've tried some IF's but don't know all the rules for formulas and
get error message for wrong data type. I've tried
=IF(X9:BB9="","",AVERAGE(X9:BB9)) but this won't work.
the #DIV/0! error message when the cell are empty. How can I eliminate this
message? I've tried some IF's but don't know all the rules for formulas and
get error message for wrong data type. I've tried
=IF(X9:BB9="","",AVERAGE(X9:BB9)) but this won't work.