top | item 46256009

(no title)

fouronnes3 | 2 months ago

You can do this with bidicalc already! You just have to model the problem correctly. If you expect the ratio to remain constant, what you actually want is a problem with a single free variable: the scale.

    A1 = 1.0       // the scale, your variable
    A2 = 6 * A1    // intermediate values
    A3 = 8 * A1 
    A4 = A2 + A3   // the sum
Now update A4 (or any other cell!) and the scale (A1, the only variable) will update as you expect.

discuss

order

No comments yet.