Tag Info

Hot answers tagged

1

One approach is to check the absolute value against a threshold, something like: =ABS(ROUND(AJ4,6)-ROUND(T4/100,6)) < 0.001 The threshold value has to be chosen knowing the magnitude of values being compared. You might compute the threshold based on the actual values, something like: =(ROUND(AJ4,6)+ROUND(T4/100,6))/(2000) This gives one-thousandth ...



Only top voted, non community-wiki answers of a minimum length are eligible