Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with IF formula choosing between three options

Topic Labels: Formulas
205 1
Showing results for 
Search instead for 
Did you mean: 

Hey guys,
so I have a test which contains a series of questions. Each question has a single select field with 3 answers. Each of these answer has a different value (for example: answer X = 9 pts; answer Y = 3 pts; answer Z = 0 pts). I need to create a field where to insert a formula that generates the exact amount of points with every answer.
Something like this:
“question 1 > IF answer = X > 9 pts; IF answer = Y > 3 pts; IF answer = Z > 0 pts”

Your help would be greatly appreciated,
thanks a lot

1 Reply 1

Hi Federico. The SWITCH statement is your friend here.

SWITCH({single select field name},
'X', 9,
'Y', 3,
'Z', 0)

You would need a formula field with a statement like this for each question field.