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

# Can someone help me what are the correct formula of these in Airtable?

Topic Labels: Formulas
216 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

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

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.