#unparseable error on multiple IF statement have tried everything!

alipeepee

I've got a simple multiple if statement. If column A is X then return Y and it's giving me Unparseable. Any advice gratefully received.

Mark.poole

@alipeepee

The first thing I notice is that you have one too many ) at the end of your formula. It should be

=IF(Activity@row = "CB FUNDING","Running the Game", IF(Activity@row = "T1 Rugby", "In the Game", IF(Activity@row = "EXPAND CLUB AND INCLUDE L&D FOR VOLUNTEERS", "In the Clubhouse")))

The way to look at is is you only have 3 if statements and no other formulas so to close off all three you need ))). If you notice in your formula the ) changes color to match the formula its closing off. If it turns to black you have too many.

Mark.poole

@alipeepee

The first thing I notice is that you have one too many ) at the end of your formula. It should be

=IF(Activity@row = "CB FUNDING","Running the Game", IF(Activity@row = "T1 Rugby", "In the Game", IF(Activity@row = "EXPAND CLUB AND INCLUDE L&D FOR VOLUNTEERS", "In the Clubhouse")))

The way to look at is is you only have 3 if statements and no other formulas so to close off all three you need ))). If you notice in your formula the ) changes color to match the formula its closing off. If it turns to black you have too many.

alipeepee

You're a legend. How I didn't spot that I don't know. Thank you so much!