Excel Formula Question

TJReget · Nov 24, 2004

This is probably simple but...
I'm looking for a formula that will subtract the smallest number from the
largest number in a range?
Any suggestions

duane · Nov 24, 2004

=max(range) - min( range

tjtjjtjt · Nov 24, 2004

This should do it:
=MAX(A1:A10)-MIN(A1:A10)

tj

TJReget · Nov 24, 2004

thanx, I'll give it a try.

tjtjjtjt said:
This should do it:
=MAX(A1:A10)-MIN(A1:A10)

tj