Excel cell value Subtraction

I have one excel sheet and i need to substract two cell variable value and result put in other cell so can you show me with example, which type it done?

1 Like

Hey @rAE_rAS

Use the DataTable in a ForEachRow activity,

Inside ForEachRow add an Assign to do the following…

CurrentRow("Column3") = CInt(CurrentRow("Column1").ToString.Trim) - CInt(CurrentRow("Column2").ToString.Trim)

Once the ForEachRow execution is completed, you will have the updated table.

Thanks
#nK