software

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 Govierquot;Larryquot; gt; wrote in message
...
gt; With a set of four cells I want to find the the highest value and
gt; lowest
gt; valuve then find the difference between them.
=MAX(A1:A4)-MIN(A1:A4)

--
Kind regards,

Niek Otten

quot;Larryquot; gt; wrote in message
...
gt; With a set of four cells I want to find the the highest value and
gt; lowest
gt; 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 Studentquot;Larryquot; wrote:

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