How to have ISBLANK, IFERROR and Average together in formula.

[taylorsm]

=IF(ISBLANK(A6),"",AVERAGE(Q6:Q723))

But I want something like =IF(ISBLANK(A6),"",IFERROR(AVERAGE(Q6:Q723)""))

I know I screwed that up, but I want the cell to be blank if A6 is blank or if no error to average, or if error, be blank.

[bhenlee]

Try:

=IFERROR(IF(A6="","",AVERAGE(Q6:Q723)),"")

[Ochimus]

Have you tried combining them?

=IF(or(ISBLANK(A6),IFERROR(AVERAGE(Q6:Q723))),"",AVERAGE(Q6:Q723))

Ochimus

[taylorsm]

"Entered too few arguments for this function"

[taylorsm]

I would like to do the same thing for this

Please Login or Register  to view this content.

so, remain blank if an error.

[Tony Valko]

Like this...

=IFERROR(IF(B7=0,"",COUNTIF(E7:Q7,"No")/COUNTA(E7:Q7)),"")

[taylorsm]

If I do

=IFERROR(IF(B7=0,"",AVERAGE(S7:S51)),"")

then I get a #NAME error now.

[Tony Valko]

What version of Excel are you trying that formula in?

IFERROR requires Excel 2007 or later.

[taylorsm]

I am using 2016

[Tony Valko]

=IFERROR(IF(B7=0,"",AVERAGE(S7:S51)),"")

There's nothing wrong with the formula.

I don't have Excel 2016 to test it in but it works in Excel 2007, 2010 and 2013.

[Ochimus]

Taylorsm,

For your original problem, following formula makes cell blank if either A6 is blank, or "averaging" Q6:Q723 generates an error.

Otherwise it shows the average of Q6:Q723:

=IF(OR(A6="",ISERR(AVERAGE(Q6:Q10))),"",AVERAGE(Q6:Q10))

Ochimus