Iterative references in LibreOffice Calc
An as yet unanswered Q from Stack Overflow [SO] enquired:
how to stop looping this formula
where the formulae were:
in B9 =16,50
in B10 =B9-B11
in B11 =B10/2
without changing text in cell.
(The above after changing
/ based on a comment. It can also be deduced from that comment that
16,5 is a value ("sixteen and a half") and that the formulae should return
11 in B10 and
5.5 in B11.)
The effect is to split the B9 value into 2/3rds (B10) and1/3rd (B11) but this was an academic exercise with the artificial constraint that:
My lecturer want to 3 option... He didn't let me to change formulas in cell, he want explanation error and "magic solve".
So, how to achieve the desired split without changing the formulae?