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.