How to use the ABS function

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

Highlight closest number

This post demonstrates how to highlight records with the closest value to a criterion, you can also choose to highlight […]

Lookup the nearest date

The image above demonstrates an array formula in cell E4 that searches for the closest date in column A to the […]