Re:The Tyranny of Spreadsheets
by quietbritishjim on Friday July 23, 2021 @04:44AM
(#27928563)
You can just spread the formula over multiple cells. Instead of
where each of the three parameters are complex formulae, you can do:
Not only is the formula now broken down into simpler chunks, you also get to inspect the component results (like watches in a breakpoint! sorta...). Then you can just hide the relevant columns if you like (B,C,D in this case). You can even use a separate sheet and hide the whole sheet if you wish.
[ Parent
| on HN ]