# How to calculate data from two columns and store it in third

Hi everyone,
I have two columns named qty and rate and i want the result of qty*rate in my third column as shown in the pic.
What is the process for that?

you require the sum?

Use the formula in write cell activity as A2 * B2, then use auto fill range to multiply the values all the range in excel

multiplication

Try this:

2. For each row result step 1.
3. Assign : row(â€śqty*reateâ€ť) = (Cint(row(â€śqtyâ€ť)) * Cint(row(â€śrateâ€ť))).ToString

@diptojyotidutta
1.Use excel application scope to read excel file.
2.In excel file apply formula in C2 cellâ€¦
=A2+B2

3.Then use auto fill range activity and pass fill range in properties panel.

try this.
Use for each row.
In for each row use assign=
row(2) =(cint(row(0))*cint(row(1))).ToString
Then write to the excel file

which write activity should i take

one which is under workbook, that is â€śwrite rangeâ€ť

ok now in write range what should be the cell and data table?

just keep the cell blank,and select the data table which u used in for each activity.Dont forget to include add headers

cool it worked. thank you so much

You are welcome.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.