MODE Function
MODE returns a correct value for 1 (along with 2) is the most frequent
numeric value given: 1 2 3 1 2 3.
If such a value does not exist, that is, there is no value with a
frequency of occurrence greater than one, MODE would return #N/A.
Maybe you're looking for something like:
=IF(ISNUMBER(MODE(Range)),MODE(Range),AVERAGE(Rang e))
Anita wrote:
I have a spreadsheet containing 6 cells say with the following values ...
1 2 3 1 2 3
I want to work out the MODE and if there isn't one, then work out an
average, but the problem is if there is no mode it displays the first cell
value (i.e in the above example that would be 1). Surely this isn't right?
Any suggestions gratefully received.
Thanks
Anita
|