Mode function - return default value rather than #N/A error if no

Posted to microsoft.public.excel.newusers

Struggling in Sheffield[_2_] Struggling in Sheffield[_2_] is offline

external usenet poster

Posts: 66

Mode function - return default value rather than #N/A error if no

Hi,
I'm using the following expression to return the mode of a list of numbers:

=IF(H1028="","",MODE(H1028:H1031))

If the four checked cells all have values but there's no two values the same
(i.e. no mode) what I need is an expression that will return me a default
value of 2 rather than the #N/A error value.

Thanks for looking,
Steve.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	1	March 11th 07 10:38 AM
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	2	March 10th 07 05:10 PM
Function displays as text, doesn't return result or error	SK_in_Austin	Excel Worksheet Functions	2	March 28th 06 07:22 PM
Excel should be able to default to a degree mode	William Lipsky	Excel Discussion (Misc queries)	0	January 15th 06 04:11 PM
Error Return Value from and INDEX(A:2,MATCH()) function	BJ	Excel Worksheet Functions	4	January 26th 05 02:59 PM

All times are GMT +1. The time now is 04:46 PM.

Menu

About Us