| |
| |||||||
| Register | Resources | FAQ/Rules | Members List | Search | Today's Posts | Mark Forums Read | 
Connect with Facebook
|
| Microsoft Office This forum is dedicated Support and Discussions on Microsoft Office, Excel, Word, PowerPoint, Templates, Clip Arts and other related queries and resources! |
 |
| | Thread Tools | Display Modes |
February 21st, 2010, 02:31 PM
| #1 (permalink) |
| Member Join Date: Feb 2010
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
 |  Get the Right Answer When writing formulas, make sure the results will be calculated as you intended. Excel adheres to the standard order of precedence for calculations and calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction. For example, =7*3 results in an answer of 22, not 36. To force a calculation to be completed before other calculations, place it inside parentheses: =(7)*3 will result in 36. If you're unsure how Excel is evaluating a formula, click on the cell and choose Tools | Formula Auditing | Evaluate Formula. Click on Evaluate to watch as each part of the formula is successively calculated. |
|   |
|
March 11th, 2010, 11:01 AM
| #2 (permalink) |
| Junior Member Join Date: Mar 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
| Re: Get the Right Answer Hi, Thanks for your information i will act upon it.
__________________ San Diego bankruptcy attorney |
|
| |
|
| Bookmarks |
| Tags |
| answer |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Sponsored links
| ||||
Linear Mode
