ABS Function

To confirm that two values are within 1 of each other you can use the ABS function.


Will display TRUE if the values in the cells are within one of each other. It will display FALSE if their difference is more than one.

1 is used as it is a common balancing check for rounded numbers.