Most valuable professional
  • Hot Topics

Excel compare two decimal values and return number of decimal places correct

I am looking for a formula that can compare two decimal values and return how many decimal values are correct. Example: Cell AK351 = 347.980813837264 Cell BU351 = 347.980813859881 I need to compare how many decimal places in cell bu351 are correct compared to cell ak351. In this example the formula would return 7. Thanks for the help. Mike

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of March 3, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel