Finding the Number Closest to Zero
Here are two formulas, one to tell you the number closest to zero in a list, and the other to tell you the address of the cell holding that number. When you know a list does not contain a zero (if it did, you could simply do a
VLOOKUP
to find it), you can apply these array formulas as shown.Recall, an array formula is applied to a cell by simultaneously pressing the
Ctrl+Shift+Enter
keys, not just Enter
. The curly braces are not typed in by you; Excel places them automatically when the array formula is properly applied.Array formula to return the cell address:
![ClosestNumberToZeroAddress](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_urrFef1eqgH4WTW7XX7f-AM5I5kqVxCDz53huOn2S2Rv4zynwG4yZ1ntvs_WCZBbfUr-tkbKwrsETvV_VjEku0XTCndYIlrbT6_KUSUG3MByngSXANOW5DiZlzGbxuY1bt_T_sTwIryH6q5WDQSrAn0qSW=s0-d)
#evba #etipfree=ADDRESS(MATCH(MIN(ABS(C7:C18)),ABS(C7:C18),0)+ROW(C7)-1,3)
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
No comments:
Post a Comment