|
|
Access ¨ Excel ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨ Word ¨ Miscellaneous ¨ Tutorials ¨ Windows
Free Downloads
¨
Suggest an Article
¨
Fix an Article
|
|
How can you evaluate the results of your formula in Excel? There's actually several ways.
We have a formula in C1, and we want to know the first part's results.
Select A1*A2 in the formula bar to see its result, as shown:
Another method is to select the cell with the formula and hit Tools®Auditing®Evaluate Formula. The underlined area is the area of the formula that will evaluate first. This more or less automates the F9 process described above, but you don't have to select each area in the formula bar.
Click evaluate to see the result of the underlined area.
Continue clicking it to see each portion of the formula's result. You'll eventually get a final result.
All contents copyright Anne Troy 2005-2006
