1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula to find number closest to zero in list (list contains both positive and negative numbers)

I have a list containing positive and negative numbers. Is there a formula I can use that will pluck out the number that is closest to zero?

https://preview.redd.it/f4946h2okc4h1.png?width=386&format=png&auto=webp&s=46f59c7d1fae483ab2182ad054d06aa08337df24

submitted by /u/MinorFX
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article