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

[Larry]

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]

Hi Larry

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

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

 

[Niek Otten]

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

 

[Gary''s Student]

If the numbers are in A1 thru A4
=MAX(A1:A4)
=MIN(A1:A4)
=MAX(A1:A4)-MIN(A1:A4)