Formula Tool IF Statement

Question

Hello,

I have a simple if statement in a formula tool. If [Amount] != [Payment] THEN "Incorrect" ELSE "Correct" ENDIF. However, I am noticing in my data that the amount and payment are off by like one cent so it labels the amount as incorrect. How can I update the if statement to label it as correct even if it is off by one cent? Any help would be greatly appreciated. Thank you!

TylerNa · Accepted Answer

Here's one approach that I think you could take. Use one formula to check for the difference between the two and then utilize that new column in the next formula to label it as correct or incorrect.