Recognising values from formulas at 4 decimal places

[anum]

Hi there, I have a a formula that is subtracting A3 from B3 for example and that shows 1.2345 in C3 when displayed at 4 decimal point. I have this comparing to another cell D3 at value 1.2345 but if I do an IF statement to say whether these are the same, they dont recognise each other as if I copy paste value cell C3 its 1.23446 for eg. Is there a workaround it to say as long as the 4 decimal points match it should show as same value?

Many Thanks!

 

[RoryA]

=IF(ROUND(C3,4)=ROUND(D3,4),"Same","Different")

for example.

 

[anum]

=IF(ROUND(C3,4)=ROUND(D3,4),"Same","Different")

for example.

ah amazing! thank you so much Rory

 

[RoryA]

Glad to help!