Hi,

I am new to formulas in Airtable. Basically, I want one field to calculate 3 different formulas, but no matter how I seem to try to “nest” them or anything, I can’t get them to work.

Here is a screenshot of what my table looks like:

I have 3 “Types of Projects”:

- Apple Videos, Product Videos
- Mac Vs PC Videos
- Commercial Videos

I also have a field called “Length”

Basically, I need the following IF formulas all in the one “amount due” field:

- If “Apple Videos, Product Videos” is chosen, it does the length number multiplied by 0.15 (rounded up to 2 decimal points.
- If “Mac Vs PC Videos” is chosen, it does the length number multiplied by 0.25 (rounded up to 2 decimal points.
- If “Commercial Videos” is chosen, it does the length number multiplied by 0.5 (rounded up to 2 decimal points.

Here are the formulas I have (however, for some reason, they all work on their own, except for the “Commercial Videos” one):

IF({Type of Project} = “Apple Videos, Product Videos”) & ROUND({Length} * .15, 2)

IF({Type of Project} = “Mac Vs PC Videos”) & ROUND({Length} * .25, 2)

IF({Type of Project} = “Commercial Videos“) & ROUND({Length} * .50, 2)

All I need is to have them all in the same column, so when I choose the “Type of Project” and then put in a number in the “Length” field, it will populate in the “Amount Due” field.

Thanks!