Mkae Mode function return "" instead of #N/A when there is no Mode

T

Tonso

Using Exel 97 for Windows, I am determining the mode for various
smples. When there is no mode, I get "#N/A". How can I get the
function to return " " instead when there is no mode?
Thanks so much,
Tonso
 
J

Joel

This will return a blank instead of #N/A

=IF(ISNA(your function)," ",your function again)
 
Top