Thread: Can I calculate a statistical range (largest minus smallest)?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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?


Reply With QuoteReply With Quote