Forum Discussion

BarryGulino1's avatar
BarryGulino1
Qrew Member
6 years ago

If"" statement using multi choice radio buttons

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.
Formulas and functions

3 Replies

Sort By
  • AlexGale's avatar
    AlexGale
    Qrew Captain
    6 years ago
    That is the way it works, as long as "Licensee" is the exact text of option. Your formula as written seems fine. 
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    6 years ago
    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.