Applying Formula in Excel

[RiyazShaik1]

Hello, Can someone suggest how to apply formula on excel column. Thanks

[Juan_ManuelFons]

You can use the Excel VBO to insert a cell value (formula) starting with ""="" then, apply an ""if loop"" to apply the changes to each row of your column. The cell references can be obtained from Data and calc stages. Good luck

[NupurSood]

Hello

You could use the action "Apply formula in Range" present in the "SPGMI - MS Excel Booster" vbo

------------------------------
Nupur Sood
Research Associate
S&P
Asia/Kolkata
------------------------------

[EvangelinaCurró]

Hi!

I have the same problem, could you explain me how "Apply formula in Range" works? or give me a example of that?

Thanks!

------------------------------
Evangelina Curró
------------------------------