Trimmed mean doesn't give expected result

Hi Winton,

Is the answer you are currently getting 22.5?

TRIMMEAN rounds down to the nearest number of two(to exclude) so using 0.34 is easier to use for a third than 0.333 etc.

That should give you the correct answer.

EDIT: Of course another way around it would be to set up a seperate cell with the formula:

=SUM(1/3)

say you put that formula in cell A1 and had the number in B1 through to B6 the next code would be:

=TRIMMEAN(B1:B6,A1)

Regards

Danny