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.
|