Forum Discussion
Solved
Blank cell after formula
I am trying to return a blank cell in place of #DIV/0! where there are no numbers in Cube 1/2/3 cells - I have tried to use two formulas, AVERAGE and IF but it's not working, please assist?? ...
Sue_Simmonds Have a look at the attached file. The formula is in the green shaded cell and it's referring to the yellow shaded range.
Sue_Simmonds Almost correct. YOu may skip the < >, thus:
=IFERROR(AVERAGE(J8:L8),"")
Hi Riny - I am getting an error - so sorry to worry you. I have 3 columns (cells J8:L8) which i need to average (cell G8) but sometimes there is no data in these columns so the #DIV/0! shows in the cell where the average should go - I don't want to see #DIV/0!, I would like the cell to be blank please?
Sue_Simmonds Have a look at the attached file. The formula is in the green shaded cell and it's referring to the yellow shaded range.
- Thanks very much Riny - that works like a bomb 👍👍👍