Forum Discussion

FionaCarr's avatar
FionaCarr
Qrew Trainee
6 years ago

Getting started question on formula fields

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

1 Reply

Sort By
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    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