Excel formula escape character
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-03-20 09:11 AM
Hi,
I was trying to use the following excel formula in Blue Prism
------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------
I was trying to use the following excel formula in Blue Prism
"=IF(ISERROR(VLOOKUP(I4,RCA!$C$1:$D$13,1,0)),"DC2","DC1")"
I am getting misplaced " error.
Can someone please guide me in resolving this?
Regards,
Prajjwal
------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-03-20 10:09 AM
Where are you getting this error? I would suggest you store the Formula in dataitem and pass it to the action.
------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-03-20 10:30 AM
The expression is not valid, since you see there are quotes in between the text, in DC2 and DC1. I need to use escape character for this, can you guide?
------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------
------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-03-20 11:58 AM
Set it as ""DC1"",""DC2""
------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
