Thread: Mkae Mode function return "" instead of #N/A when there is no Mode
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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


Reply With QuoteReply With Quote