| 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 | |||
![Mike R.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
