Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Excel: find number farthest from 0

Hi,

I have a row of numbers in Excel, such as

       -2, -4, 0, 1 3

I need to return the value that is the farthest from 0.  In this example, -4

how?

thanks
0
caherciveen
Asked:
caherciveen
  • 2
  • 2
1 Solution
 
CluskittCommented:
Something like:
=MAX(ABS(A1:A10))
0
 
caherciveenAuthor Commented:
That returns 4, not -4
0
 
barry houdiniCommented:
Try this

=IF(MAX(A1:A10)>MIN(A1:A10)*-1,MAX(A1,A10),MIN(A1:A10))

regards, barry
0
 
barry houdiniCommented:
Sorry there's a typo in that - should be this version

=IF(MAX(A1:A10)>=MIN(A1:A10)*-1,MAX(A1:A10),MIN(A1:A10))

If you have 4 and -4 in the dataset then it will return the positive number

barry
0
 
caherciveenAuthor Commented:
ah, ok, cool
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now