QA Tips – Comparing digits on an excel file

Issue: In an Excel file, when digit values from two columns are compared, even if the values are the same, the result is “FALSE.”

Solution:

Use the ‘ROUND’ operation to compare cells.

For eg., =IF(ROUND(A1,0)=ROUND(C1,0),”TRUE”,”FALSE”)