Aug 07, 2019 09:17 AM
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!
Aug 07, 2019 01:33 PM
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.
Aug 07, 2019 04:10 PM
It worked :grinning_face_with_big_eyes: Thank you!!