Posted on Wednesday, 18/06/2014 Validation in Excel using the ABS function Avoid issues with negatives When doing validations in Excel you often need to check values against a tolerance figure, usually 1 cent or 1 dollar.