Getting started question on formula fields

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I'm a beginner. I want to create a formula field that will take the selected text from a multiple choice field and convert it into $. This is for a student enrollment app where parents can select 5 full day, 3 full day, etc. enrollment options. Each option has its own fee.  I have created a formula field: If([Enrollment Type]="5 Full Day",360). Clearly it doesn't work. I want the result to be $360 if 5 Full Day is the enrollment type (that's the field name) selected.
Photo of fiona carr

fiona carr

  • 182 Points 100 badge 2x thumb
  • Hopeful and like learning

Posted 3 months ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
When building an IF statement you also need an "else" condition.

If([Enrollment Type]="5 Full Day",360,null)

if "enrollment type" is equal to "5 Full Day", then 360, otherwise zero