Can I calculate a statistical range (largest minus smallest)?

lolee624 · Nov 14, 2006

How can I calculate a statistical range (largest number minus smallest number
) when numbers are in random order?

Dave F · Nov 14, 2006

=max(A1:A10)-min(A1:A10)

Adjust range reference to suit your needs.

Dave

Bernard Liengme · Nov 14, 2006

=MAX(A1:A100)-Min(A1:A100)
best wishes