Apply a complex formula in excel

Help
1

How can I apply a complex excel formula (containing text within quotation marks) with UiPath?
The formula I´d like to apply is this one:
=iferror(if(vlookup(D6;TABLA;N°;false)=G6;“OK”;“REVISAR”);“PENDIENTE”)

2

Can you try replacing every double quote (“) with two double quotes (”") @aferreira054?

1 Like
3

@aferreira054 another way is to replace double quotes with Chr(34). You’d use a write cell or write range to paste it back into excel. It MUST be the excel read range, workbook read range will not work.

So your string would be: "=iferror(if(vlookup(D6;TABLA;N°;false)=G6;“ + Chr(34) + "OK” + Chr(34) + ";“ + Chr(34) + "REVISAR” + Chr(34) + ");“ + Chr(34) + "PENDIENTE” + Chr(34) + ")"

1 Like
4

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