M

#### Malcolm

(J28) that totals rates and a cell (J29) that is the average daily rate

total, rate/total rooms. Iâ€™m using the formula =AVERAGE(J28/C27). The only

problem is until I actually input a number into C27 I get the #DIV/0!

displayed in my ADR cell (J29). I donâ€™t always need this data so is there a

way I can input the formula and not have the #DIV/0! in cell J29?

Thanks,

Malcolm