Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Trouble with IF

Solved
Jump to Solution
729 0
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!