Create new value if cell reference is correct

Dear RPA Developer,

Need your advise how to multiply if value reference is correct

Transaction Amount DR CR FLAG New value
1,000.00 Credit IF column E= Credit then column D*-1
10,890.33 Credit
10,890.33 Credit
1,000.00 Credit
1,613,607.00 Debit IF column E= Debit then column D*1

Expected i need create new value to

i have use activity
1 read csv file.
2 build data table
3 for each row * to build new value
4 add data row
5 write range

Thank you so much.


Check below post for your reference

Hope this helps you