Averaging without #DIV0!
hi
vary your formula a tad
=IF(c27=0,0,average(j28/c27))
thought i haven't seen the average formula used quite that way.
but if c27 is zero then the above formual will put a zero in the cell
instead of #DIV/0
regards
FSt1
"Malcolm" wrote:
Im using a worksheet that has a cell (C27) that totals rooms and a cell
(J28) that totals rates and a cell (J29) that is the average daily rate
total, rate/total rooms. Im 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 dont 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
|