Help

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 
Search instead for 
Did you mean: 

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

1 Reply 1

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.