Round up 2 decimal all column E in Excel

I want to round up 2 decimal all column E in Excel

Please guide me about it.

@fairymemay

You can use as below

Math.Round(yourVariable, 2)

Also you can use Format Value activity

Hope this helps you

@fairymemay
find below some demo cases on rounding and formating to 2 decimals
grafik

go for a for each row and loop over the rows
with the method of choice you can convert within an assign activity

Also have a look to Balarevas Component:
grafik

2 Likes

@Srini84 Use Fomat Value Activities like this ?

@Srini84 I use Math.Round(yourVariable, 2) , but error

image

Please suggest me.

@fairymemay

Check as below

BlankProcess23 (2).zip (7.4 KB)

Hope this may helps you

Thanks

@Srini84 If I want to read column E in excel.
I will edit it right ?

image

@fairymemay

Just add your columnName in Double quotes

Thanks

@Srini84 I change it , but i error DataRound.xlsx (8.9 KB)


image

@fairymemay

You can try with row(4)

Thanks

Thank you @ppr.

Hi @ppr,

Here is the video demo also.

Regards
Balamurugan.S