Inputting formulas in excel

excel

#1

image

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?


#2

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?


#3

@qaz1 try below file.

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

Sample excel file.

sh1.xlsx (7.9 KB)


#4

for each row
switch(col1)
case “A”
case “B”


#5

thank you so much @Manjuts90 .