Thread: Find the difference between the high & low value of a given set.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default Find the difference between the high & low value of a given set.
Hi Larry

One way
=MAX(A1:A4)-MIN(A1:A4)

or =LARGE(A1:A4,1)=SMALL(A1,A4,1)

--
Regards

Roger Govier


"Larry" wrote in message
...
With a set of four cells I want to find the the highest value and
lowest
valuve then find the difference between them.


Reply With QuoteReply With Quote