Formula in excel dynamic

Help StudioX
,
1

Hi ,

Let me explain the scenario

I have installment months which is dynamic , example 24, 18

So now in the excel I have to apply the formula for only for these number of rows

How to do this ??

1 Like
2

Hi,

We can use below steps to achieve the requirement you mentioned.

  1. Use write cell to write the formula in the cell.

  2. Use Auto fill range activity to auto populate formula in this we have to provide the installment months as dynamic variable.

Please refer the attached sample work flow i have created. thanks.

ExcelFormulaDemo.zip (9.2 KB)

1 Like
3

Hi Kiran,

Thanks for your reply but I am facing this error when i am replacing the formula with mine .

My formula is “=IF(B2-C2>=0,B2-C2,”“)”

This is the error message which i am getting

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=IF(B2-C2>=0,B2-C2,”)" has a wrong format;
► Excel is busy;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.

4

Hi,

I think the formula is wrong. In your formula habing wrong double quotes which triggered formula error. Please try like below.

=IF(B2-C2>=0,B2-C2,“”)

5

It works @kiran. Thank u.