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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Find the difference between the high & low value of a given set. (https://www.excelbanter.com/excel-discussion-misc-queries/67926-find-difference-between-high-low-value-given-set.html)

Larry

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

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

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.

Niek Otten

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

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

--
Kind regards,

Niek Otten

"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.

Gary''s Student

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.

All times are GMT +1. The time now is 10:11 AM.