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 Use =IFERROR( < your formula > , "")
Hello Riny - many thanks for coming online to assist me.
My current formula is basic - +AVERAGE(J8:L8) - would it need to look like this - =IFERROR(< AVERAGE(J8:L8)>,"")
tA
sUE
My current formula is basic - +AVERAGE(J8:L8) - would it need to look like this - =IFERROR(< AVERAGE(J8:L8)>,"")
tA
sUE
- SORRY MY CURRENT FORMULA IS =AVERAGE(J8:L8)
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?