Hi all,

I have a sheet which looks at three cells and produces either the MODE or AVERAGE depending on the three numbers. I'm using the formula:

=IFERROR(MODE(Q13:S13),AVERAGE(Q13:S13))

When I copy the formula down through rows I get an error (#DIV/0!) if say Q14 is empty.

I've tried =IF(ISERROR(Q14,"",IFERROR(MODE(Q14:S14),AVERAGE(Q14:S14)))

but it says there's an error in the formula. I've also tried using =ISERROR but get the same result.

Any ideas?

TIA

Jack