# =IF statement not recognizing two cells as matched

Using this formula to check if two values in the same row match, and returning "Yes", "No", or "Hold" to display the associated symbols.

=IF(ISBLANK([Column A]@row), "Hold", IF([Column A]@row = [Column B]@row, "Yes", "No"))

If they match it returns "yes": green checkmark

If they both have values but they don't match it returns the "no": red X

If column A is blank it returns "hold": orange !

This appears to be working everywhere in the sheet except for one instance where it is looking at two currency columns (confirmed they are the same currency) where both cells are $0.01. This one cell is returning the red X indicating a mismatch where it should be indicating the green checkmark.

Please advise if you have any suggestions!

If anyone knows a way to build an acceptable variance in to this formula (i.e. within $1.00 for currency columns) that would be helpful too!

Cheers :)

## Answers

## Help Article Resources

#### Categories

- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives

Check out the

**Formula Handbook template!**