Hi Everyone,

I’ve been using the **Write Range** for formula input but doesn’t seem to write in the range that I have input.

Any help will be much appreciated.

Hi Everyone,

I’ve been using the **Write Range** for formula input but doesn’t seem to write in the range that I have input.

Any help will be much appreciated.

Hi

Are you writing the formula for multiple cells are one cell?

you can use write cell to write formulas that will work better

Hi Abisha,

Thank you for your response.

Yes I’m writing a formula in multiple cells. I have also tried Write Cell method but doesn’t input the correct formula that I have declared because my formula has many *“”* that’s why uipath declares short string

If possible can you share screenshot or xaml file?

Hi,

i have checked your workflow. Why does it write as false ?

Hi Vishal,

Because when I use **Write Cell** activity, it doesn’t write **=IF(C2="","",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE))** which is my formula

but it writes

**=IF(C2=",",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE))**

thats why it returns to false

Try this in the write range

**"=IF(C2="""","""",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE))"**

1 Like

Wow thanks! It worked!!!

2 Likes

happy learning

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.