Show cell empty if result is an error due to empty source

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

if Q14:S14 are all empty or non numeric you will get an error, if this is the case what value do you wish to return? =IFERROR(MODE(Q13:S13),IFERROR(AVERAGE(Q13:S13)),"What do you want to display?")

Dav

That got it Tony, thanks!