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- SORRY MY CURRENT FORMULA IS =AVERAGE(J8:L8)
Sue_Simmonds Almost correct. YOu may skip the < >, thus:
=IFERROR(AVERAGE(J8:L8),"")
