Get our new Windows 7 eBook (PDF) for $7 with 70+ Tips. Download Now!
Use The Evaluate Formula Option In Excel 2003
- 1
- Add a Comment
Formulas can often be difficult in Excel. If you aren’t a math whiz, you may not recall the standard order of precedence that Excel uses. For example, within a formula, multiplication is performed before any addition or subtraction and calculations within parenthesis are performed before any others. If you do not understand how Excel is performing a calculation, you can use the Evaluate Formula option to make it clearer.
To use the Evaluate Formula option in Excel 2003:
- Within Excel, select the cell you want to evaluate.
- From the Tools menu, point to Formula Auditing and click Evaluate Formula.
- Click the Evaluate button to watch as Excel evaluates each step of the formula.
- To view the evaluation again, click Restart.
- First Team Tyrant In-Ground Basketball Hoop with 72 Inch Steel Backboard
- 0.20 g 3700 6mm Airsoft Gun BB
- 0.25 g 2200 Airsoft BB
- Accelerade - 100 Capsules
- Rhino, Medium Cargo Mat for a Hyundai pp5993-pos4585593
- AutoSport Chuka Mats, Medium Cargo Mat for a Hyundai pp4961-pos4297615
- Protect-A-Mat, Medium Trunk Mat for a Hyundai pp5994-pos4630768
- Double-Tufted Mats, Medium Trunk Mat for a Hyundai pp5991-pos4496920
- AutoSport Sisal Mats, Medium Trunk Mat for a Hyundai pp4960-pos4262043
- Double-Tufted Mats, Medium Cargo Mat for a Hyundai pp5991-pos4496919
- E-Z Roll Sliding Door Track Set - 70-1/2″ Track for 6 ft Door Opening - 7072HU
- Garage Door Insulation Kit for 2 Car Garage Door
- Keyed Aluminum Screen and Storm Door Mortise Latch; 3″ Screw Holes - K5053
- John Louis Home Standard Shelving System for 6-10′ Closets- Red Mahogany
- Teiber Designer Carved Westminster Long Door Chime - CM-CA4-RC
- CRL Top Hung Double Track Sliding Door 118″ Aluminum Track - 118in Long - REPLACED BY CRL3319 *** DISCONTINUED *** - K3907
- GuardWise Corning 32 In. x 22 In. Glass Block Basement Window Solid 114175
- TE 2-S Deluxe Rotary Hammer Drill - HRHD1
- LIFTMASTER Garage Door Opener Remote Control 81LM
- Intellicode GIT-1 ONE Button Garage Door Opener Remote 33069R
- Universal Garage Door Receiver Set W/ 2 Remotes & Keyless Entry Pad
- Liftmaster Chamberlain 1/2 HP Chain Drive Garage Door Opener Model CG40D
- CRL Overhead Track Carriage Assembly for OT Series Sliding and Bi-Fold Doors - 0TCA
- Garage Door Insulation Kit for 1 Car Garage Door
- Aluminum Screen and Storm Door Mortise Latch 3″ Screw Holes - K5052
One Comment
the.boffin
March 31st, 2009
at 4:26am
Years ago when I first learnt algebra, I was taught the nmemonic BODMAS - brackets, of, division, multiplication, addition, subtraction - for the order of math operations. “Of” is just an alternative to multiplication, when you say “half of”, for instance. Excel sticks to this order.