Math solver formula

[Paul_Danyliuk]

I think Max had it done earlier. It can indeed be done with black magic but only in a button, not a live formula for a column.

A Tiny SHEET (using a 9 x 20 grid of Formulas)

I needed a simple no-frills spreadsheet-like page for a client project. So I built the following and decided to publish it so that others can use it as they want. You must open it in Coda to see it properly. Each ‘cell’ is a formula, labeled A 1 thru I 20 (sorry but coda puts a space between the letter and the number). Thus, when you click on a cell, you edit the formula. Move up one line to the 0 and replace it. You then replace it with a number or an entire formula. The formula can refe…

It is probably possible to build either an ASL or a shunting yard / stack machine impl in a formula for simple [a1*b1]+[a2*b2]+...+[aN*bN] polynomials if all that’s required is multiplication and addition, no brackets or other operators.