Range: Maximum - Minimum Value

carson · Mar 20th, 2002, 01:32 PM

Does anyone know how to set excel to identify a sample of values and work out the Maximum value from the minimum value.
eg:
2
4
6
8
10
=8

Aladin Akyurek · Mar 20th, 2002, 01:34 PM

Quote:

On 2002-03-20 12:32, carson wrote:
Does anyone know how to set excel to identify a sample of values and work out the Maximum value from the minimum value.
eg:
2
4
6
8
10
=8

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

where A1:A10 houses the values of interest.

abe · Mar 20th, 2002, 01:37 PM

=MAX(A2:A6)-MIN(A2:A6)

carson · Mar 20th, 2002, 01:48 PM

Thanks for the quick answer.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 01:32 PM	#1
carson New Member Join Date: Mar 2002 Posts: 5	Does anyone know how to set excel to identify a sample of values and work out the Maximum value from the minimum value. eg: 2 4 6 8 10 =8

Mar 20th, 2002, 01:37 PM	#3
abe New Member Join Date: Mar 2002 Location: Boston Posts: 4	=MAX(A2:A6)-MIN(A2:A6)

Mar 20th, 2002, 01:48 PM	#4
carson New Member Join Date: Mar 2002 Posts: 5	Thanks for the quick answer.