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

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

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

This will return a blank instead of #N/A

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

"Tonso" wrote:

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