Inputting formulas in excel


In excel, I want to implement that if Col1 is C, then the output column would be defaulted to ‘Not applicable’.

If Col1 is A, output column would be the formula = CONCATENATE(Col2, Col3).

If Col1 is B, output column would be the formula = CONCATENATE(Col3).

How can I do this with over a thousand lines of rows?

I would use the Switch activity. put the content of Col A into a string then define the concatenation (or not) for A B and C?

@qaz1 try below file.

col-----.xaml (18.1 KB)

Sample excel file.

sh1.xlsx (7.9 KB)

1 Like

for each row
case “A”
case “B”

thank you so much @Manjuts90 .

1 Like