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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Mkae Mode function return "" instead of #N/A when there is no Mode (https://www.excelbanter.com/excel-discussion-misc-queries/134303-mkae-mode-function-return-instead-n-when-there-no-mode.html)

Tonso

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

Gary''s Student

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

=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

Tonso

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

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

All times are GMT +1. The time now is 10:37 PM.