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

Tagged with

#AI formula generation techniques
#row zero
#rows.com
#formula generator
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#closest to zero
#positive numbers
#negative numbers
#formula
#list
#excel
#plucking out
#value retrieval
#numerical analysis
#data extraction
#mathematical function
#comparison
#absolute value