If"" statement using multi choice radio buttons

Question

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.

alexgale · Answer

That is the way it works, as long as "Licensee" is the exact text of option. Your formula as written seems fine.&nbsp;

evanmartinez · Answer

One 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.&nbsp;

barrygulino1 · Answer

It was an error like you said.&nbsp; Sorry for wasting both of your time.

Forum Discussion

If"" statement using multi choice radio buttons

Related Content

formula help "if statement"

Dynamic Rule - Or statement?

Jinja If statement equals field value

Nested "IF" statements

Using "and" in If(