Excel Formula Question

Guest · 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

Guest · Nov 24, 2004

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

tj

Guest · Nov 24, 2004

thanx, I'll give it a try.

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

tj

smallest to largest	9	Jan 1, 2010
How to subtract a number from a Mergefield?	0	Feb 12, 2025
Cannot sort data	1	Feb 13, 2010
Cannot sort data	6	Feb 11, 2010
ranking numbers in a column	7	Jan 18, 2010
How do you randomly assign numbers without getting duplicates?	6	Jan 4, 2010
Sorting numbers	4	Jun 2, 2009
First Value in Sorted Column is Not Sorted Properly	3	Jun 26, 2009

Ask a Question