how to roundup/down to 2 decimal when 3rd decimal larger than 5

[donglimyong]

Hi.

I would like to ask how to roundup/down to 2 decimal point when 3rd decimal larger than or equal to 5

example 5.235 roundup to 5.24 or if 5.234 round down to 5.23

[Kamboj]

use

Please Login or Register  to view this content.

[Kamboj]

if you have value in a1 then in b1 use =round(a1,2)