I have a Excelfile with two Columns, with I have to compare. It looks like this:
First Column Second Column Results
I need to compare the First Column (2) with the Second Column (7).
If First C. > Second C. i need to subtract them (First C. - Second C.)
Otherwise, I have to multiply them (First C. * Second C.).
The Result needs to go in the “Result” column.
I struggle to find a way, that calculates each row with the specified.
I used a Excel Application Scope to read the Columns, used the “Get range Table” to get a string for First C. and Second C.
With the “Flow Decision”, I compared them (First C. > Second C.).
Then, I used in an other Excel Application Scope the “For each row”-function to assign the rows and tried to write the the result back into excel with “Write Cell”.
Can someone help me please?
Thanks in advance,