Tolerance

I have 27,000 lines of data to check for errors in a % value. I want to be able to create an “If” statement or alike that will enable me to ignore if the variation is within + or - 0.02%. Anything over or under 0.02% would bring up and error.
There must be a simple way to do this

Make sense... I hope so.

Ta

Depends how your data is set up but if you want to check if A1 is within 0.02% of B1 try something like

=ABS(A1-B1)<=0.02%

gives TRUE if A1 is within the tolerated margin, FALSE otherwise