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" <Larry@discussions.microsoft.com> wrote in message
news:02D4CA0F-49F9-4884-ACC0-2971855DC0A5@microsoft.com...
> 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" <Larry@discussions.microsoft.com> wrote in message
news:02D4CA0F-49F9-4884-ACC0-2971855DC0A5@microsoft.com...
> 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.