Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel What Function shows value between highest and lowest number
I need to know the function that calculates the difference between the
highest number and teh lowest number in a set of numbers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel What Function shows value between highest and lowest number
=Max(A1:A100)-Min(A1:A100)
"Mike R." wrote: I need to know the function that calculates the difference between the highest number and teh lowest number in a set of numbers. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel What Function shows value between highest and lowest number
=MAX(A1:A10)-MIN(A1:A10)
"Mike R." <Mike wrote in message ... I need to know the function that calculates the difference between the highest number and teh lowest number in a set of numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to make highest #, 1 color, & lowest # another? | New Users to Excel | |||
what function do I use for excel to choose the 2nd highest number | Excel Worksheet Functions | |||
Highlight highest / lowest number in a row | Excel Discussion (Misc queries) | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel |