Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using MODE
Is there a way to display some arbitrary word or symbol in a cell if there is
no mode. I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non zero answers, but sometimes there are only one non zero numbersand sometimes there are multiple non zero numbers but only one of each number. How do I get it to display " ", or "no mode", etc. Instead of ginving me the #N/A error in the cell. Thanks |
#2
|
|||
|
|||
Try the following to test for #VALUE and #N/A
=IF(OR(ISERR(MODE(D9)),ISNA(MODE(D9))),"No Mode",MODE("D9")) -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "sip8316" wrote: Is there a way to display some arbitrary word or symbol in a cell if there is no mode. I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non zero answers, but sometimes there are only one non zero numbersand sometimes there are multiple non zero numbers but only one of each number. How do I get it to display " ", or "no mode", etc. Instead of ginving me the #N/A error in the cell. Thanks |
#3
|
|||
|
|||
That does get rid of the Error when I put it in,
But when I use that it takes the mode of all the values in the column. I want to only take the mode of the non zero values in the column like I was before, Scott "galimi" wrote: Try the following to test for #VALUE and #N/A =IF(OR(ISERR(MODE(D9)),ISNA(MODE(D9))),"No Mode",MODE("D9")) -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "sip8316" wrote: Is there a way to display some arbitrary word or symbol in a cell if there is no mode. I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non zero answers, but sometimes there are only one non zero numbersand sometimes there are multiple non zero numbers but only one of each number. How do I get it to display " ", or "no mode", etc. Instead of ginving me the #N/A error in the cell. Thanks |
#4
|
|||
|
|||
Try...
=IF(ISNA(MODE(IF(A1:A10<0,A1:A10))),"No Mode",MODE(IF(A1:A10<0,A1:A10))) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "sip8316" wrote: Is there a way to display some arbitrary word or symbol in a cell if there is no mode. I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non zero answers, but sometimes there are only one non zero numbersand sometimes there are multiple non zero numbers but only one of each number. How do I get it to display " ", or "no mode", etc. Instead of ginving me the #N/A error in the cell. Thanks |
#5
|
|||
|
|||
Thanks Domenic,
That worked great Scott "Domenic" wrote: Try... =IF(ISNA(MODE(IF(A1:A10<0,A1:A10))),"No Mode",MODE(IF(A1:A10<0,A1:A10))) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "sip8316" wrote: Is there a way to display some arbitrary word or symbol in a cell if there is no mode. I use this to take the mode: =MODE(IF(BV35:BV40<0,BV35:BV40)) of all non zero answers, but sometimes there are only one non zero numbersand sometimes there are multiple non zero numbers but only one of each number. How do I get it to display " ", or "no mode", etc. Instead of ginving me the #N/A error in the cell. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off [Group] mode? | Excel Discussion (Misc queries) | |||
Mode Function with Criteria | Excel Worksheet Functions | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |