Unsure which acitivity to use

[Pyx]

hi all, if i wish to replace columns B n C using their own values whereby if the markup value is more thn 100, we minus 100, what function in UiPath allows me to replace the values ? the formula is =IF(C2>100,C2-100,C2) for column C.

[Pyx]

do i use the replace function? if yes, what values do i input ? when i try to input my file address, it doesnt work as it says string type cannot be converted to IReadRangeRef

[Yoichi]

Hi,

There are some ways to achieve it.
For example, ForEachExcelRow will help you, as the following.

Regards,

[Pyx]

hi, ive tried, but hereis the error
also could u show the formula in ur assign save to?

[Yoichi]

HI,

The above expression is the following.

CurrentRow("material mark_up (without PIN)") = CInt(CurrentRow("material mark_up (without PIN)").ToString)-100

If still remians error, can you try to remove left side expression then retype the above expression?

Regards,

[Pyx]

gotit! thanks!!