IsClose Function

Returns TRUE or FALSE depending on whether the leading significant digits match.

Syntax

IsClose( number1, number2 [, digits] )

Examples

IsClose( 0, 0 ) → true
IsClose( 0, 1e-4 ) → false
IsClose( 0, 1e-9 ) → true
IsClose( 0, 1e-4, 3 ) → true
IsClose( 123.4567, 123.4568, 6 ) → true
IsClose( 0.00001234567, 0.00001234568, 6 ) → true
IsClose( 1.234567e-5, 1.234568e-5, 6 ) → true (same as previous example)
IsClose( 1, 1.00000001 ) → false
IsClose( 1, 1.000000001 ) → true
IsClose( 1, 0.999999999 ) → true

Note: In the last example, the digits do not match, but the number is considered close, as in the previous example.

Further explanation

This function can be used when floating-point rounding occurs. The number of digits to compare is determined by the digits parameter, which has a default value of 8.