Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jul 27, 2022 04:58 AM
Hello, I’m currently copying the formula from our excel file to airtable. But some of the formulas are having errors in Airtable.
Can someone help me what are the correct formula of these in Airtable to make it work?
Correct Formula for:
6mo Avg
=iferror(GPM*(if(Months#>6,6,“”)),“”)
6mo Avg%
{WIP: 6mon Ave$}/{Purchase Price}
ROI Growth
=iferror(Actual Growth on Purchase / Cash Required,)
COC Return
=iferror(Cashflow / Cash Required)
Total ROI
=iferror((Actual Growth on Purchase + Cashflow) / Cash required)
6MA
=iferror(PCM$ * (if(Month>6,6,“”)),“”)
Thank you
Jul 27, 2022 05:04 AM
That is because Airtable’s formula use a different language from Excel. While some of the vocabulary and grammar is similar between the two languages (simple arithmetic) others are very different. There is no iferror
in Airtable’s formula language, and Airtable formulas don’t start with equal signs.
I suggest looking at the Airtable formula reference to see what is available in Airtable.