On Mar 10, 11:58 am, Gary''s Student
wrote:
=IF(ISNA(MODE()),"",MODE())

--
Gary''s Student
gsnu200709



"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- Hide quoted text -

- Show quoted text -

Thanks! Works Perfect!!!
Tonso