# Min/Max of absolute value, show negative if negative

1. ## Min/Max of absolute value, show negative if negative

I'm trying to find the largest and smallest absolute value of a range. This can be done with

``Please Login or Register  to view this content.``
and then pressing ctrl+shift+enter. However, that will give me a positive number even if the smallest/largest absolute value was negative. I would like the number to be negative if it originally was negative.

I was thinking of doing something like

``Please Login or Register  to view this content.``
but i don't quite remember the MATCH function.. There might be an easier way though?

I've attached an example workbook. I would like to find the largest and smallest absolute value of the range, and if negative, the number should show as negative.

Thankful for any help!

2. ## Re: Min/Max of absolute value, show negative if negative

Solved it using

``Please Login or Register  to view this content.``
calculated as an array (ctrl+shift+enter).

Someone might have a more elegant solution though?

3. ## Re: Min/Max of absolute value, show negative if negative

=IFERROR(VLOOKUP(MIN((ABS(A4:A278)));A4:A278;1;0);MIN((ABS(A4:A278)))*-1)
Try this array formula

It's almost the same

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1