|
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 |
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 |
| All times are GMT +1. The time now is 07:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com