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!