Help

IF Multiple Select choice = x, then (amount*.25)

Topic Labels: Formulas
Solved
Jump to Solution
851 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Luna_Lewis
4 - Data Explorer
4 - Data Explorer

Hi, I’m very new to Airtable.
I am crafting a budget base for freelance business. I have an Income table and I am trying to only calculate tax for untaxed income.

I have a multiple choice selection with options “FREELANCE” and “PAYROLL”
then I have a field for calculating the tax (amount*.25)

I want to be able to only calculate tax for the records that are selected FREELANCE…

IF multiple select = FREELANCE then (amount*.25)
IF multiple select = PAYROLL then 0

I have no idea how to go about doing this, all my attempts have failed.

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Luna_Lewis,

Welcome to Airtable!

I have the following recommendations:

  1. Make sure the Income field is set as a Number or Currency, not as a Text.

  2. Use this formula IF({Employee Type}="Freelance",Income*0.25,0). (change Employee Type to your Field name with the select option)

This should work.

BR,
Mo

See Solution in Thread

3 Replies 3
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Luna_Lewis,

Welcome to Airtable!

I have the following recommendations:

  1. Make sure the Income field is set as a Number or Currency, not as a Text.

  2. Use this formula IF({Employee Type}="Freelance",Income*0.25,0). (change Employee Type to your Field name with the select option)

This should work.

BR,
Mo

Wow. So it is that simple.
Thank you!
I was just missing the brackets I think.

Im glad it worked :slightly_smiling_face: please mark it as solved.