ABS Function

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

=ABS(A1-B1)<=1

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.

Related Posts