| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get the maximum absolute value of a range of numbers?
I have a range of numbers
10 5 2 6 -1 -5 -25 I want to have a single formula that will give me the maximum absolute value of that range. The answer should be 25 but I can only get it to answer 10. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum absolute values of a column of numbers in Excel | Excel Worksheet Functions | |||
| Statistical smoothing a range of numbers - match average more clos | Excel Worksheet Functions | |||
| How do i set up a range of numbers which prompts at a particular n | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Threaded Mode
