Question: how to calculate the absolute difference between two numbers in excel?
Answer: Subtract the expected value from the actual value (or the other way round) and get the absolute value of the difference: ABS(A2-B2) Check if the absolute value is less than or equal to the allowed tolerance: ABS(A2-B2)<=C2. Use the IF statement to return the desired messages.