Hi,
I have a range of numbers from -100 to 100 in a row, and would like to return the greatest absolute value, including the negative sign if it happens to be a negative value.
i.e. if the number happens to be -70, using the =ABS function only returns "70", instead of -70.
Using the =MAX function also only returns the greatest positive value, even if there is a larger negative absolute value.
Thanks
Bookmarks