Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Trouble with IF

Topic Labels: Base design
Solved
Jump to Solution
996 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
9 - Sun
9 - Sun

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
9 - Sun
9 - Sun

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!