| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Mode Problem
I WAS WONDERING IF SOMEONE COULD HELP ME WITH MODE: I HAVE A FUNCTION THAT TAKES THE MODE OF A LIST OF NUMBER. IF NONE OF THE NUMBERS REPEAT, IT RETURNS \"N/A\" AND SCREWS UP MY WHOLE SHEET. IS THERE ANY WAY AROUND THIS? -- DArinello ------------------------------------------------------------------------ DArinello's Profile: http://www.excelforum.com/member.php...o&userid=25589 View this thread: http://www.excelforum.com/showthread...hreadid=390413 |
|
#2
|
|||
|
|||
|
You don't say what you would like to return but I have assumed 0:
=IF(ISNA(MODE(A1:A20)),0,MODE(A1:A20)) Hope this helps Rowan "DArinello" wrote: I WAS WONDERING IF SOMEONE COULD HELP ME WITH MODE: I HAVE A FUNCTION THAT TAKES THE MODE OF A LIST OF NUMBER. IF NONE OF THE NUMBERS REPEAT, IT RETURNS \"N/A\" AND SCREWS UP MY WHOLE SHEET. IS THERE ANY WAY AROUND THIS? -- DArinello ------------------------------------------------------------------------ DArinello's Profile: http://www.excelforum.com/member.php...o&userid=25589 View this thread: http://www.excelforum.com/showthread...hreadid=390413 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Book1 changes itself? | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| 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 | |||
Hybrid Mode
