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

Question

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 Answer

Hi @Luna_Lewis,Welcome to Airtable!I have the following recommendations:Make sure the Income field is set as a Number or Currency, not as a Text.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 · Answer

Hi @Luna_Lewis,Welcome to Airtable!I have the following recommendations:Make sure the Income field is set as a Number or Currency, not as a Text.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,MoWow. So it is that simple.Thank you!I was just missing the brackets I think.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded