Discussions

Expand all | Collapse all

If"" statement using multi choice radio buttons

  • 1.  If"" statement using multi choice radio buttons

    Posted 10-05-2018 16:35
    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.


  • 2.  RE: If"" statement using multi choice radio buttons

    Bronze
    Contributor
    Posted 10-05-2018 17:52
    That is the way it works, as long as "Licensee" is the exact text of option. Your formula as written seems fine. 


  • 3.  RE: If"" statement using multi choice radio buttons

    Top
    Contributor
    Posted 10-05-2018 17:55
    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. 


  • 4.  RE: If"" statement using multi choice radio buttons

    Posted 10-05-2018 19:32
    It was an error like you said.  Sorry for wasting both of your time.