title: Google Sheet Excel AVERAGE formula
body: <p>I just want to ask if why does the result of the formula is not the same? I used 95, 93, 95, 95, 96, 94 as the value.</p>
  <p>Formula 1:
  <code>=IF(ISERROR(AVERAGE(I11,N11,S11,X11,AC11,AH11,AM11,AR11,AW11)),&quot;0&quot;,AVERAGE(I11,N11,S11,X11,ACB11,AH11,AM11,AR11,AW11))</code></p>
  <p>For Formula 1, I need to get the value by cell.</p>
  <p>Here's the value for each cell:</p>
  <p>I11 = 93, N11 = 95, S11 = none, X11 = 95, AC11 = 96, AH11 = 94, AM11 = none, AR11 = none and AW11 = 95</p>
  <p>Formula 2:
  <code>=IFERROR(ROUND(AVERAGE(J17:J25),0),&quot;&quot;)</code></p>
  <p>Result: <code>Formula 1 is 94.40</code> while <code>Formula 2 is 95</code></p>