concatenating if statements
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.