=IF statement not recognizing two cells as matched

GHobbs

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 :)

RossL

@GHobbs

I would check to see if you bump the number of decimal points if one of them is actually slightly less than $0.01. For example it might be $0.00976

GHobbs

Thanks @RossL Checked that too! Extending the decimals to the max just shows a string of 0's for as many decimal places it will allow.