Not able to understand how to write formula in excel using write cell

Help StudioX
,
1

Hello Awesome people,

i want to write formula for sum of two columns using write cell activity.
but my question is how does it work for example in this below screenshot i am passing value "=sum(A1+B1) " using for each row activity in each cell of column C .
ideally it should pass =sum(A1+B1) in every row in column C and should not give expected result but instead it is giving expected result.

in short i want to understand how below solution work (screen shot.)

image
image1009×696 21.8 KB

image

1 Like
2

Hello @VIKAS_PANDEY282

It is the expected behaviour. It will increment automatically.

for you scenario use =SUM(A$1+B$1)

2 Likes