I need to know if two values match, they come from two excel cells that are the result of a formula. At first glance in excel you can see that the two values for example “133.44” and “133.44” are the same, but when I get the values with the get cell value activity in a variable of type double Uipath will add new decimals, for example “133.4445” and “133.4449” which when trying to compare the values VALUE1=VALUE2 will give me a false result, how can I compare if two values are exactly the same as they are visible in excel “133.44”
Excel is rounding the values because the cells are formatted to 2 decimal places. 133.44 isn’t the real value, it’s the rounded value. 133.4445 is the real value in the cell.
You can round them the same way Excel is doing.
1 Like
Thank you! It works.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.