how do i average the 2 smallest number in a range of six numbers

Z

zetatstrat

I tried (small(a1:a6,1)+small(a1:a6,2)/2, but got an incorrect number.
Is there problem with syntax, or perhaps another to accomplish what I am
trying to achieve.

Zetstrat
 
T

Trevor Shuttleworth

Try:

(small(a1:a6,1)+small(a1:a6,2))/2
or
small(a1:a6,1)/2+small(a1:a6,2)/2

Regards

Trevor
 
T

tjtjjtjt

This should do it:
=((SMALL(A1:A6,1))+(SMALL(A1:A6,2)))/2

Your formula calculates out of order. Excel always divides before it adds in
a formula, unless you group parts of the equation together with parentheses.

tj
 
Z

zetatstrat

zetatstrat said:
I tried (small(a1:a6,1)+small(a1:a6,2)/2, but got an incorrect number.
Is there problem with syntax, or perhaps another to accomplish what I am
trying to achieve.

Zetstrat
Click to expand...

Thanks to everyone for their help
 
T

tjtjjtjt

You are missing a few parentheses, but Frank and Jerry both provided more
concise formulas anyway.

tj
 
Top