Find formulas fast. Inputs can be so controversial. Garbage in, garbage out. But at least they hold still and they are easy to change. Inputs don't really need to be debugged, so they take up a lot less attention.
Formulas are more troublesome.
Most writers format formulas the same way as constant inputs, so the reader must move the cursor around to find the formula. Panko wrote that we should not audit our own spreadsheet. We need someone else to look at it, because we each tend to be over-confident and in love with our own work. Click here to find out more. Copyright 2000 John F. Raffensperger .