Archive | March, 2016

Dealing with Intermediate Computations

In complex spreadsheets, it’s not unusual to find cells whose values are computed from complicated¬†combinations of subexpressions that contain many functions and operators. Trying to build formulas in these cells to produce the desired results can be very difficult. The reasons for this are three-fold. First, if a formula is complicated, then it may contain […]