Excel If function through UIPath

Help Studio
, ,
#1

Hi everyone,
I’have tried to find a answer for my problem but without luck.

The problem:
I am iterating through an excel file and my goal is to use the “if” function in every column where a value is present.
My last attempt was as shown in the pictures:

Capture
Capture985×163 14.5 KB

Without the “=” this shown formula is being written into the cell as a string, but if “=” is added excel is deleting everything.

Thank you all in advance.

Bye

#2

I was not able to add two picture so I will continue here.
First i assigned the expression shown above to a variable - IfFunction - please see in the picture below, and I am trying to write it for each column in cell “E”+ counter.tostring

tempsnip

#3

Hi @D_A

What condition u need ?

#4

Hi @NIVED,

thank you very much for responding.

If you are talking about the if function, it should look like this, for row 2:

cell E2=if(D2<0;0;C2-10)

Thank you.