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.

Hi Larry

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

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

--
Regards

Roger Govier


"Larry" <[email protected]> wrote in message
news:[email protected]...
> With a set of four cells I want to find the the highest value and
> lowest
> valuve then find the difference between them.

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

--
Kind regards,

Niek Otten

"Larry" <[email protected]> wrote in message
news:[email protected]...
> With a set of four cells I want to find the the highest value and
> lowest
> valuve then find the difference between them.

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.