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
 
G

Guest

This will return a blank instead of #N/A

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MODE function where there are no common functions. 1
Mode Function or MODE Function -- Can't get it to work!! 4
add symbols to autocrrect in excel 2007 1
Finding the lowest mode in a set of numbers 3
Return 0 instead of N/A 2
The mode function 17
Using MODE 4
Mode function in excel using Text 5

Top