Skip to main content

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.

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 :grinning_face_with_big_eyes: Thank you!!

Reply


Terms & Conditions