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 ar

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.