Mode Problem

D

DArinello

I WAS WONDERING IF SOMEONE COULD HELP ME WITH MODE:

I HAVE A FUNCTION THAT TAKES THE MODE OF A LIST OF NUMBER. IF NONE O
THE NUMBERS REPEAT, IT RETURNS \"N/A\" AND SCREWS UP MY WHOLE SHEET.
IS THERE ANY WAY AROUND THIS
 
R

Rowan

You don't say what you would like to return but I have assumed 0:

=IF(ISNA(MODE(A1:A20)),0,MODE(A1:A20))

Hope this helps
Rowan
 
Top