# How to multiply?

I want to multiply the days and the distance.

cdbl(CurrentRow.ByField(â€śDaysâ€ť))*cdbl(CurrentRow.ByField(â€śDistanceâ€ť))

=> Use read range workbook activity to read the excel and store in to a datatable.
=> Use for each row in datatable activity to iterate each row
=> Take an assign activity inside for each, create a variable called result it will be in double
=> Assign â†’ Result = CDbl(row(â€śColumn1â€ť)) * CDbl(row(â€śColumn2â€ť))
=> You can use the Result variable to pass anywhere.

Check the below workflow for better understanding.

Check the output below, for your reference I write the result in the result column.

Hope it helps!!

Use an assign activity where left side is multipliedValue and of type Double and right side is CDbl(currentRows(â€śDaysâ€ť))*CDbl(currentRows(â€śDistanceâ€ť))

CurrentRow(â€śDaysâ€ť).ToString=Var1
Days=Convert.ToInt32(Var1)
CurrentRow(â€śDistanceâ€ť).ToString=Var2
Assign: doubleVariable = Convert.ToDouble(Var2)
Days* doubleVariable

BlankProcess4.zip (153.4 KB)

O/P :
Input.xlsx (9.4 KB)

I hope it helps!!

If you got the solution for your query. Please mark it as solution to close the loop.

Regards,

How do I use range H1:J4 and write to column K?

I hope it helps!!

Thank you so much!!!

1 Like

I changed the header to the date.