Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 04, 2020 11:01 PM
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.
Solved! Go to Solution.
Mar 04, 2020 11:08 PM
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
Mar 04, 2020 11:08 PM
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
Mar 05, 2020 04:16 PM
Wow. So it is that simple.
Thank you!
I was just missing the brackets I think.
Mar 05, 2020 10:13 PM
Im glad it worked :slightly_smiling_face: please mark it as solved.