| ▲ | geon 21 hours ago | |
It would make more sense to preserve the ratio if possible. | ||
| ▲ | pxx 15 hours ago | parent | next [-] | |
Yeah, this concept is interesting but the fact that the simplest test case gives what's fundamentally a surprising result is very annoying. It also doesn't help that in the example, the expected outcome of 53.3333/46.6667 isn't even considered. | ||
| ▲ | fouronnes3 14 hours ago | parent | prev | next [-] | |
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.
Now update A4 (or any other cell!) and the scale (A1, the only variable) will update as you expect. | ||
| ▲ | rafabulsing 15 hours ago | parent | prev [-] | |
To get that, you could pass the ratio explicitly. C = 5A + 7B | ||