Hello,
I have a spreadsheet in which I am averaging the values in three cells. I get a valid result as long there is a value entered in at least one of the cells that I am referencing. However there will be times when there are no values entered in those three cells, and when that is the case, a "#DIV/0!" shows up in the cell that would normally display the average. How can I keep this message from showing up if all three cells are empty.
For example, in cell B1 I have entered:
=AVERAGE(A1,A2,A3)
As long is there is a number in A1,A2, or A3 I get the proper result, but if A1,A2 and A3 are all empty, "#DIV/0!" shows up in cell B1.
How can I avoid this?
Thanks
Randy
Bookmarks