concatenating if statements

Jag Johal

Hi Guys,

First post and would really appreciate your help. I am trying to combine multiple if statements in one cell. I am not looking for AND / OR support but how I can return multiple values.

IF([Bananas]2 = "x", [Bananas]1 + ", ", "") + IF([Apples]2= "x", [Apples]1 + ",","")

When i run the first if statement it works fine but when I reference the next column along it says its an invalid operation. Any help would be appreciated.

Regards

J

ron.judenberg112096

I copied your code exactly and got the expected result

check for typos. Make sure you have an = sign at the start of the formula

=IF(Bananas2 = "x", Bananas1 + ", ", "") + IF(Apples2 = "x", Apples1 + ",", "")

Jag Johal

Thanks Ron. Haha. Not sure why i could not get it to work for me. Thankfully I used a Collect instead and it is all working fine. Thanks for coming back.

ron.judenberg112096

I copied your code exactly and got the expected result

check for typos. Make sure you have an = sign at the start of the formula

=IF(Bananas2 = "x", Bananas1 + ", ", "") + IF(Apples2 = "x", Apples1 + ",", "")

Jag Johal

Thanks Ron. Haha. Not sure why i could not get it to work for me. Thankfully I used a Collect instead and it is all working fine. Thanks for coming back.