Thread: Find the difference between the high & low value of a given set.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Find the difference between the high & low value of a given set.
If the numbers are in A1 thru A4
=MAX(A1:A4)
=MIN(A1:A4)
=MAX(A1:A4)-MIN(A1:A4)
--
Gary's Student


"Larry" wrote:

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