Dependent formulas?

Hello all,

I’m pretty new to airtable so bear with me! I’m trying to set up an IF calculation. This is what I have as of now:

IF({Secondary Adj}>0, “AVERAGE({Main Adj},{Secondary Adj})”, “{Main Adj}+{Secondary Adj}”-{Commitment (Hours)}*50-{Internal Contribution}

Essentially what I’m trying to accomplish is if the “Secondary Adj” field is greater that 0 then an average between it and the “Main Adj” field is created. If it is less than 0 then a sum of “Secondary Adj” and “Main Adj” is created. Is this possible?

Thanks in advance!

If you remove the quotation marks in your formula and put a closing parenthesis at the end, it should do what you want it to do.

It worked :smiley: Thank you!!