Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Can Airtable solve equations with variables?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

1
5747
8

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 25, 2017 01:47 PM

I’m trying to figure out if AirTable can solve equations with unknown variables.

For instance, a break-even analysis based on data in the table.

(Revenue per unit ⨉ Units sold) − (Fixed costs + Cost per unit ⨉ Units sold) = 0

(200 ⨉ Units Sold) − (1000 + 100 ⨉ Units sold) = 0

Where Units sold is the unknown variable (“x”), and I would like to know the value of “x” where the equation returns 0 (break-even).

A normal equation solver would give:

(200*x)−(1000+100*x) = 0

x = 10

So, could I get “10” to display using an AirTable Formula?

Thanks!!

Reply

8 Replies 8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 25, 2017 10:23 PM

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 26, 2017 06:59 PM

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 26, 2017 08:22 PM

Depend on your technical proficiency, you may find it easier to set up an API call to perform the calculation using a different method (JS or Google Sheets).

Or a low-tech way is to set up a custom view that displays records where the {Calculation Result} field is empty, a sheet with the equation solver set up in Google Sheets, and then have Zapier action that monitors the custom view in AirTable, pushes any new records that appear over to Google Sheets, then pulls the result back to AirTable.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Feb 05, 2022 06:26 AM

Just use the javascript module on the automation section

it’s very easy

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2022 10:57 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 17, 2022 05:03 PM

`eval()`

. However, sometimes you can find a minified version of a library and copy/paste the entire minified library into your script.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 23, 2022 10:16 PM

Thank you. A colleague suggested using the AirTable API to get data into Google CoLab for analysis.

If anyone has done that, I’d appreciate any pointers.

Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Mar 15, 2024 05:03 AM

I've got a similar challenge, I'd like to calculate BEP for a retail store sales, however it takes an iteration method to do that, in Excel or google sheet I'd use the "Goal seek" formula, is there anything similar in Airtable?