#DIV/0! error Excel 2016

[Tesnobay]

hi, in Cells T4:T6 i will enter numbers, in T7 I will be averaging those 3 numbers. =Average(t4:t6). I drag that formulas across 20 column. I get the DIV error in the columns that have not been filled yet. Despite my best efforts, I cannot make the error go away and say return a blank or a 0 (zero).

this is a simplified version of my problem.

Please help

TIA

 

[jtakw]

Hi,

You can wrap your formula with IFFERROR:

Excel 2010
	T
1
Sheet11

Cell Formulas
Range	Formula
T1	=IFERROR(AVERAGE(T4:T6),"")

 

[Tesnobay]

Hi,

You can wrap your formula with IFFERROR:

Excel 2010

	T

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

</tbody>

Sheet11​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]T1[/TH]
[TD="align: left"]=IFERROR(AVERAGE(T4:T6),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you!!

 

[jtakw]

You're welcome.