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!!