Hi Abfabrob
You did not post your formula, but I think you are using a straightforward
formula. Just after the "=" in this cell's formula, insert the words
IF(<address of your empty cell here="","", - now go right to the end of the
formula and insertt a closing bracket ")" there
Regards
"abfabrob" wrote:
I have created a spreadshhet and in one column I can enter data and the
"total" is automatically populated as an AVERAGE for the week's stats. It
works fine when I input the data. But when it is left blank (e.g. the column
for Thursday 14, for which I have no data yet) the following text appears in
the Average cell: "#DIV/0!" (without the quotation marks).
Can I hide or delete this so that it looks blank until data is entered
without removing the formula?
Thank you,
Rob,
Teesside,
UK
|