If/then formula needed for two different variables, needs to be consistant

[Mile029]

Hi I'm trying to compare two numbers with an if/then formula. the problem I'm having is that the formula needs to be changed each time because sometimes it's 3 numbers and sometimes it's 2 numbers. Is there a way to have a consistent formula without need to change. Please see attached sheet. Thanks.

[Paul]

Hi Mile,

Perhaps this will work for you?

=IF(LEFT(B1,FIND(".",B1)-1)+0=VALUE(A1),"YES","NO")

This function finds the first "." in the string in B1 and returns everything to the left of it. It then adds 0 to this string to convert it to an actual number. It then takes that number and compares it to the value of the numeric string in A1. If they match you'll see YES, otherwise NO.

[Mile029]

Okay, first off thank you, works beautifully!
Secondly I didn't know of the "FIND" formula, good to know and will use in the future
Lastly, you are very good, I broke down each piece of the formula to see how it's comparing, very nice work. Thanks again.