J
John Calder
Hi
In cell R88 I have the following formula
=AVERAGE(R76:R87)
It works fine as soon as I enter data in the range but when there is no data
in the range it returns a #DIV/0! error.
This looks unsightly on the sheet and was wondering if there was a way that
I could surpress this error when there is no data entered.
Thanks
John
In cell R88 I have the following formula
=AVERAGE(R76:R87)
It works fine as soon as I enter data in the range but when there is no data
in the range it returns a #DIV/0! error.
This looks unsightly on the sheet and was wondering if there was a way that
I could surpress this error when there is no data entered.
Thanks
John