News for hackers. Stuff that matters.
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

  A3: IF(<boolean>, <result if true>, <result if false>)
where each of the three parameters are complex formulae, you can do:

  A3: IF(B3, C3, D3)
  B3: <boolean>
  C3: <X>
  D3: <Y>
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.
Re:The Tyranny of Spreadsheets by DataGata on Tuesday July 27, 2021 @12:46AM (#27968740)
You say this but it still feels gross to do.