Now that I’ve talked about how to keep references from being relative, and the sort of tricks that allows you to do, I’m going to talk about a fun little trick that relative formulas let you do quickly and easily: incremental formulas.

Incremental formulas are formulas where there are a lot of identical (but relative) formulas, and the results of one formula depend on the previous one. The Fibbonaccci sequence is one example outside of spreadsheets. Continue reading Incremental formulas