| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Mode function - return default value rather than #N/A error if no
=IF(ISERROR(MODE(A1028:A31)),2,MODE(A1028:A31))
Regards, Stefi €˛Struggling in Sheffield€¯ ezt Ć*rta: 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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Mode function - return default value rather than #N/A error if
Hi Stefi,
Thank you very much, worked a treat. Steve. "Stefi" wrote: =IF(ISERROR(MODE(A1028:A31)),2,MODE(A1028:A31)) Regards, Stefi €˛Struggling in Sheffield€¯ ezt Ć*rta: 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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Mode function - return default value rather than #N/A error if
You are welcome! Thanks for the feedback!
Stefi €˛Struggling in Sheffield€¯ ezt Ć*rta: Hi Stefi, Thank you very much, worked a treat. Steve. "Stefi" wrote: =IF(ISERROR(MODE(A1028:A31)),2,MODE(A1028:A31)) Regards, Stefi €˛Struggling in Sheffield€¯ ezt Ć*rta: 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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Mode function - return default value rather than #N/A error if no
Here's another way...
=IF(H1028<"",LOOKUP(9.99999999999999E+307,CHOOSE( {1,2},2,MODE(H1028:H103 1))),"") Hope this helps! http://www.xl-central.com In article , Struggling in Sheffield wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| Function displays as text, doesn't return result or error | Excel Worksheet Functions | |||
| Excel should be able to default to a degree mode | Excel Discussion (Misc queries) | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
![Struggling in Sheffield[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
