How to get a formula to correctly verify a number by disregarding the last two decimal digits

[ecrodrig]

So I am trying to match 2 numbers from different workbooks calculated via formulas. The problem is that one number is coming up as 1575.30, and the other is coming up as 1575.3025. I want to be able to either round it when doing the match or have a wild card to disregard everything past the 2nd decimal. So match 1575.30 and ignore the last two digits.

=LET(Verify, XLOOKUP(A4,'[RFS billings.xlsx]2021 2022'!$A:$A,'[RFS billings.xlsx]2021 2022'!$AA:$AA), IF(Verify='Master_Data_File (2)'!U4, "good", "check"))

The output from the Xlookup formula is 1575.3025 the number in U4 is 1575.30, so my result is coming up as "check" when it really should be good.

Any help is appreciated. Thanks.

 

[Alex Blakenburg]

Wouldn't it jus be a matter of chaging your comparison part to this ?

IF(ROUND(Verify,2)=U4

 

[ecrodrig]

Wouldn't it jus be a matter of chaging your comparison part to this ?

IF(ROUND(Verify,2)=U4

You are a genius! That worked like a charm. Thanks

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.