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."
Page 1 / 1
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"))
thanks Bill!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.