Compare attribute columns based on value ranges?
I want to compare the values from 2 attribute columns from 2 different excel files.. e.g radius1 and radius2,
now I want to "identify" those as equal (meaning, their ID is the same) if they are equal in a certain range, e.g radius1 = 1.77 and radius 2 = 1.78
like in a formula: if radius1 = between 1.02*radius2 and 0.98*radius2, then its equal!
then I want to join all the rows based on that equal row entries if it matches above formula.
is it somehow possible to identify equality based on ranges like above?