I am trying to calculate a fee based on an option chosen in a radio button multi choice field. What is the value of the choice? I tried using the text of the choice and it doesn't work. So:
If([Type of Closing]="Licensee", [Notary Fee]+([Title Insurance]*0.25), [Notary Fee]+([Title Insurance]*0.5))
"Licensee" is the first option on the list. Do I need to put a number? How do I make this work.
Question
If"" statement using multi choice radio buttons
This topic has been closed for replies.
That is the way it works, as long as "Licensee" is the exact text of option. Your formula as written seems fine.
+17One thing that can be helpful is to go into the field settings for that multiple choice field and make sure there aren't any leading or trailing spaces in the entry in the multiple choice field or in the formula you are writing. You can also try copying the specific entry right out of the field settings and right into your formula.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.