If function/ Logical test question

[sjc4]

is it possible to write a logical test to a certain amount of decimal places? for instance I have two rows of data. One row is written out to the 10th decimal place while the other is only written out to the third decimal place. I want to write an IF logical test to only check if they are correct to only the second decimal place. How can I do that?

 

[VoG]

Try like this

=IF(ROUND(A1,2)=ROUND(A2,2),"Yes","No")

 

[sjc4]

money. thanks.

Try like this

=IF(ROUND(A1,2)=ROUND(A2,2),"Yes","No")