Rounding cell values

[RPA_Path]

Hi,

I am reading a cell that has a value of 21,232,282,.96

I want to round it based on the 4th number. so in this case, I want the output to be 21.2 since the 4th number is 3.

Another case is: 25,371,311.88
expected output: 25.4
since the 4th number is 7

[Yoichi]

Hi,

Hope the following sample helps you.

dblVar = Double.Parse(yourValue.ToString,System.Globalization.NumberStyles.Any)

Then

Math.Round(dblVar/1000000,1,System.MidpointRounding.AwayFromZero)

Regards,