You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how to pass Switch excel formula as text format blue prism
- Thread starter rudyfritz
- Start date
I guess this is what you are looking for-
Value in the cell reference AE3 will be checked against the Collection values W1 thru W5 for a match and the respective 'valor' is selected. I added "No Match" to the expression in case there is no match.
Keep us posted.
"=SWITCH(AE3,"&[Weights.W1]&","&"""valor1"""&","&[Weights.W2]&","&"""valor2"""&","&[Weights.W3]&","&"""valor3"""&","&[Weights.W4]&","&"""valor4"""&","&[Weights.W5]&","&"""valor5"""&"," & """No Match""" & ")"Value in the cell reference AE3 will be checked against the Collection values W1 thru W5 for a match and the respective 'valor' is selected. I added "No Match" to the expression in case there is no match.
Keep us posted.
Last edited:
I guess this is what you are looking for-
"=SWITCH(AE3,"&[Weights.W1]&","&"""valor1"""&","&[Weights.W2]&","&"""valor2"""&","&[Weights.W3]&","&"""valor3"""&","&[Weights.W4]&","&"""valor4"""&","&[Weights.W5]&","&"""valor5"""&"," & """No Match""" & ")"
Value in the cell reference AE3 will be checked against the Collection values W1 thru W5 for a match and the respective 'valor' is selected. I added "No Match" to the expression in case there is no match.
Keep us posted.
Thanks for the answer, I helped solve the problem, instead of using the ":" character, you must use "," for this Switch formula.
Thank you.
yep! you got it right!Thanks for the answer, I helped solve the problem, instead of using the ":" character, you must use "," for this Switch formula.
Thank you.