Find the difference between the high & low value of a given set.

Guest · Jan 27, 2006

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

Roger Govier · Jan 27, 2006

Hi Larry

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

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

Niek Otten · Jan 27, 2006

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

Guest · Jan 27, 2006

If the numbers are in A1 thru A4
=MAX(A1:A4)
=MIN(A1:A4)
=MAX(A1:A4)-MIN(A1:A4)

difference between the lowest and next lowest value	4	Dec 14, 2008
Trying to find additional ranges outside of min, max, and average	2	Aug 17, 2013
Compare Cells of Text and Return Highest Value based on a Customiz	1	Dec 1, 2009
How to determine the values based on given conditions?	11	Dec 1, 2007
Need to create a SUM for data in a row of cells containing IF fun.	1	Feb 23, 2005
How do I record new Highest / Lowest numbers as data changes in ce	2	Sep 4, 2008
Showing the top result from a range of cells	6	Feb 26, 2011
Excel finding top of range	1	Nov 19, 2009

Ask a Question