Blank cell after formula

[Sue_Simmonds]

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??

			7 Days	14 Days	28 Days
Average MPa (7 days)	Average MPa (14 days)	Average MPa (28 days)	Cube 1	Cube 2	Cube 3	Cube 1	Cube 2	Cube 3	Cube 4	Cube 5	Cube 6
#DIV/0!	40.6	#DIV/0!				41.3	40.4	40.2
#DIV/0!	39.2	#DIV/0!				40.3	38.7	38.7
34.0	#DIV/0!	#DIV/0!	33.9	34.5	33.5
33.7	#DIV/0!	#DIV/0!	33.4	32.9	34.9
#DIV/0!	#DIV/0!	40.1							39.6	39.8	40.8
#DIV/0!	#DIV/0!	40.2							39.2	40.1	41.4

[#2]

@Sue_Simmonds Use =IFERROR( < your formula > , "")

[#3]

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

[#4]

SORRY MY CURRENT FORMULA IS =AVERAGE(J8:L8)

[#5]

@Sue_Simmonds Almost correct. YOu may skip the < >, thus:

=IFERROR(AVERAGE(J8:L8),"")

[#6]

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?

[#7 · Accepted solution]

@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.

[#8]

Thanks very much Riny - that works like a bomb :thumbs_up::thumbs_up::thumbs_up: