Troubleshooting a Long Formula
|
If you create a long worksheet
formula that is not returning the expected result, you can drag the
pointer to select part of the formula in the formula bar, and then press
F9. When you do this, only the selected portion of the formula is
evaluated.
Important If you press ENTER, that part of your formula
is lost, so be sure to press ESC instead. However, if you
mistakenly press ENTER, try pressing CTRL+Z to undo the change.
|
|