I'm no spreadsheet expert, and i haven't done anything that heavy in Numbers yet (though i did design a variable-interest mortgage analyzer from scratch once in ClarisWorks, sans template). But isn't it customary to add a hidden column and use the cells there as a sort of scratchpad for intermediate values and/or ancillary control structures? [as indicated —once set up —such cells remain hidden (unseen and unprinted).]
