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

[Luna_Lewis]

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.

[Mohamed_Swella1 · Accepted solution]

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

[Luna_Lewis]

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

[Mohamed_Swella1]

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