This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!