Thanks Domenic,

That worked great

Scott

"Domenic" wrote:

Try...

=IF(ISNA(MODE(IF(A1:A10<0,A1:A10))),"No
Mode",MODE(IF(A1:A10<0,A1:A10)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
"sip8316" wrote:

Is there a way to display some arbitrary word or symbol in a cell if there is
no mode.

I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non
zero answers, but sometimes there are only one non zero numbersand sometimes
there are multiple non zero numbers but only one of each number.

How do I get it to display " ", or "no mode", etc. Instead of ginving me the
#N/A error in the cell.

Thanks