Help

Trouble with IF

Topic Labels: Base design
Solved
Jump to Solution
327 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ARTHUR_BENNETT
5 - Automation Enthusiast
5 - Automation Enthusiast

What is wrong with this IF statement?  

IF({Sonrise Home} = "CH", "Sonrise Children's Home"), IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))

"Sorry, there was a problem saving this field. Invalid formula. Please check your formula text."

 

 
1 Solution

Accepted Solutions
BillH
8 - Airtable Astronomer
8 - Airtable Astronomer

You have an extra ")" after the first IF.  Try

IF({Sonrise Home} = "CH", "Sonrise Children's Home", IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))

See Solution in Thread

2 Replies 2
BillH
8 - Airtable Astronomer
8 - Airtable Astronomer

You have an extra ")" after the first IF.  Try

IF({Sonrise Home} = "CH", "Sonrise Children's Home", IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))

ARTHUR_BENNETT
5 - Automation Enthusiast
5 - Automation Enthusiast

thanks Bill!