## Archive for ABS function

Converts negative numbers to positive numbers, in other words, the ABS function removes the sign. Excel Function Syntax ABS(number) Arguments […]

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

This post decribes how to highlight records with closest value to a criterion. You can also choose to highlight the […]

Array formula in E3: =INDEX(A1:A10, MATCH(MIN(ABS(A1:A10-$E$1)), ABS(A1:A10-$E$1), 0)) Recommended articles: How to enter an array formula Select cell E3 Type […]