I have 3 columns of data.
My criteria is this;
if there is a number in column A that is within +/-10 of a value in cell in the same column A AND
if there is a number in column B that is within +/-10 of a value in cell in the same column B AND
if there is a number in column C that is within +/-10 of a value in cell in the same column C
THEN
RETURN
TRUE
For example
Column A Column B Column C Result
378 53 45 FALSE
383 38 30 FALSE
379 0 52 TRUE
379 0 50 TRUE