TechSpott - Computer and technology forums

Go Back   TechSpott - Computer and technology forums > Software and Utilities > Microsoft Office
Microsoft Office This forum is dedicated Support and Discussions on Microsoft Office, Excel, Word, PowerPoint, Templates, Clip Arts and other related queries and resources!

Reply
 
Thread Tools Display Modes
Old February 21st, 2010, 03:31 PM   #1 (permalink)
rash
Member
 
Join Date: Feb 2010
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
rash is an unknown quantity at this point
Default 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.
rash is offline   Reply With Quote Share with Facebook
Old March 11th, 2010, 12:01 PM   #2 (permalink)
marknelson
TechSpott Newbie
 
Join Date: Mar 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
marknelson is an unknown quantity at this point
Default Re: Get the Right Answer

Hi,

Thanks for your information i will act upon it.
__________________
San Diego bankruptcy attorney
marknelson is offline   Reply With Quote Share with Facebook
Reply

Bookmarks

Tags
answer


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


 
Forum Stats
Members: 14,313
Threads: 20,320
Posts: 27,653
Total Online: 52

Newest Member: RoyasiaSnamma

Latest Threads

Advertisements

Support our advertisers!

Amazon
Sears
Macys
1800flowers.com
Drugstore.com


Carbonite Online-Backups
Tiger Direct
Tech Depot
Buy.com
Office Depot
Fatcow
HostGator


TripsNow.us
Marriott
Expedia
CheapTickets.com
OneTravel
Hotwire

Are you a Fan?

Share this on Facebook

Tag Cloud

Partner Links


Contact Us - Home - Archive - Privacy Statement - Top - Copyright © 2009-2010, TechSpott - All times are GMT -4. Time is 03:42 AM

Powered by vBulletin® Copyright © Jelsoft Enterprises Ltd. :: SEO by vBSEO