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

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

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

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

Adjust range reference to suit your needs.

Dave
--
Brevity is the soul of wit.


"lolee624" wrote:

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

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

=MAX(A1:A100)-Min(A1:A100)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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