Debugging Formulas
To troubleshoot complex formulas select the
cell containing it and then click the = (Equal sign) to the left of the
formula bar, this will activate the "Paste Function". To step
through your formula simply click in the part of the formula you want to
debug.