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

[diptojyotidutta]

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?

[vishal.kp (vishal)]

you require the sum?

[HareeshMR (Hareesh Madasi)]

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

[diptojyotidutta]

multiplication

[TanVuong (MrErrorRobot)]

Try this:

1. Read rang Excel.
2. For each row result step 1.
3. Assign : row(“qty*reate”) = (Cint(row(“qty”)) * Cint(row(“rate”))).ToString

[monika.c (Monika Chaudhari)]

@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.

[iVishalNayak]

try this.
Read the excel file.
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

[diptojyotidutta]

which write activity should i take

[iVishalNayak]

one which is under workbook, that is “write range”

[diptojyotidutta]

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

[iVishalNayak]

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

[diptojyotidutta]

cool it worked. thank you so much

[iVishalNayak]

You are welcome.