Equations with MODE

S

sip8316

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
 
Top