| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max absolute number
I am looking for the biggest absolute number in a range.
For example: -20 3 50 40 I hope to get 20 as a result I tried max(ABS(D2:D5)) but that does not work. Of course I can use an intermedite range and fiirst convert all my data to ABS then do a max - but I hope there is another way. Many thanks. Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display absolute value of complex number | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER? | Excel Discussion (Misc queries) | |||
| Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
| How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)? | Excel Discussion (Misc queries) | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
Threaded Mode
