I am trying to perform calculations on cells in excel rows and I need to do this in a loop -
Col1 Col 2 Col3
3 2 5
5 6 8
I need the result to be (3-2)*5 and (5-6)*8. There are other columns in excel too.
Is there a way to automate this calculation using loops. I can do it for one row using expression. But unable to work with multiple list variables here.
Appreciate your response.