How to write Excel formula inside foreach loop

Help Studio
1

Hi I am trying to apply excel formula inside foreach loop. But i cant figure it out.

as you can see the formula above and under “Particulars” is the expected output

image

Here is my sample code but it didnt work
image

Thank you in advance
-Vincent

2

@Vincent_Nuestro

You have to place = inside the quote as below

"=X - MB

Hope this may help you

Thanks

3

Hi @Vincent_Nuestro,

It just required the double quotes to be included. Hope this helps.

image
image1000×437 16 KB