Tag Info

New answers tagged


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 ...

Top 50 recent answers are included