"If" statement using multi choice radio buttons

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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.
Photo of Barry Gulino

Barry Gulino

  • 80 Points 75 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Alex Gale

Alex Gale

  • 1,124 Points 1k badge 2x thumb
That is the way it works, as long as "Licensee" is the exact text of option. Your formula as written seems fine. 
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 9,214 Points 5k badge 2x thumb
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. 
Photo of Barry Gulino

Barry Gulino

  • 80 Points 75 badge 2x thumb
It was an error like you said.  Sorry for wasting both of your time.