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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

or =LARGE(A1:A4,1)=SMALL(A1,A4,1)
 
If the numbers are in A1 thru A4
=MAX(A1:A4)
=MIN(A1:A4)
=MAX(A1:A4)-MIN(A1:A4)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the values based on given conditions? 11
Trying to find additional ranges outside of min, max, and average 2
Need to create a SUM for data in a row of cells containing IF fun. 1
difference between the lowest and next lowest value 4
Compare Cells of Text and Return Highest Value based on a Customiz 1
How do I record new Highest / Lowest numbers as data changes in ce 2
copy-pasting a cell and finding lows and highs 1
finding is a value is betwen a range of values 5

Back
Top