Multiple IF Formulas - cannot figure out why it's producing a "0"

Meagan Harte

Hey all - I'm working on a formula that built as an IF formula. It has multiple "IF" statements, and I'm stumped as to why it's producing a zero (although it's likely because there are too many "IF" formulas) and what to use in leu of this formula.

I want the formula to put out an abbreviation based off the team name - this is a helper row for an overall larger formula.

Here is the formula: =IF([Team Name]@row = "Team 1", "(" + "T1" + ")") + IF([Team Name]@row = "Team 2", "(" + "T2" + ")") + IF([Team Name]@row = "Team 3", "(" + "T3" + ")") + IF([Team Name]@row = "Team 4", "(" + "T4" + ")") + IF([Team Name]@row = "Team 5", "(" + "T5" + ")") + IF([Team Name]@row = "Team 6", "(" + "T6" + ")") + IF([Team Name]@row = "Team 7", "(" + "T7" + ")")

Any help is appreciated!

Leibel S

@Meagan Harte

change your formula syntax to the below. Should fix it.

=IF([Team Name]@row = "Team 1", "(T1)","") 

Leibel S

@Meagan Harte

change your formula syntax to the below. Should fix it.

=IF([Team Name]@row = "Team 1", "(T1)","") 

Meagan Harte

@Leibel Shuchat - thank you!!! I swear I thought I tried that, but I had not. Thank you!