Calculating Part of a Formula

You can calculate part of a long formula by highlighting a portion of the formula bar and pressing F9. Be sure to press the escape key afterwards, otherwise the calculated result will replace the formula. This is a great way to isolate problems in a long formula.