Can ROUND work within an IF(AND statement?

[ecrodrig]

Hello everyone,

First, I am so grateful for this forum. Thanks so much for everyone's input and suggestions. I am learning so much . Now on to my situation:

This is a follow-up question to a question I previously posted. Since I received a solution for my original question, I am posting the follow-up as a new thread.

Original Question:
=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.

Answer received which worked: IF(ROUND(Verify,2)=U4

Now I am trying to add that formula into my Full formula, so I wonder if IF(ROUND(Verify, 2)=U4 would work within an IF(And statement? Trying to do the following:

IF(AND(Closed, Complete, (ROUND(Verify,2)='Master_Data_File (2)'!U4,"good"," check"))


"Closed" and "Complete" are other calculations within the Full formula. I need "Closed," "Complete," and "Verify" to all be true so I can get "good"; otherwise, it needs to say "Check."

When I do the above formula, I get an Error: There is a problem with this formula. Not trying to type a formula? I am doing something incorrectly.

Any help is appreciated. Thanks.

 

[Alex Blakenburg]

You didn’t put a closing bracket for the AND after U4.

 

[ecrodrig]

You didn’t put a closing bracket for the AND after U4.

Just caught that and fixed it, but now seems the round isn't working as it should since I am once again getting check rather than good. If I do just the round formula by itself, it works but when I add it into the full formula it isn't.

This picture shows my output. The #N/A are not found which I need to figure out how to change to an actual statement and then the "check " should be "good" Like the second picture. First pic is the full formula seconf pic just the IF(Round statement.

second pic. Here the good and check are correct.

 

[ecrodrig]

Just caught that and fixed it, but now seems the round isn't working as it should since I am once again getting check rather than good. If I do just the round formula by itself, it works but when I add it into the full formula it isn't.

This picture shows my output. The #N/A are not found which I need to figure out how to change to an actual statement and then the "check " should be "good" Like the second picture. First pic is the full formula seconf pic just the IF(Round statement.
View attachment 75789

second pic. Here the good and check are correct.

View attachment 75791

I figured it out...I needed to do the ROUND function at the calculation level. So for it to work I did the following:

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


This now works Slowly but surely I am getting there!!