

Subject:
microsoft excel question
Category: Business and Money > Accounting Asked by: tpopga List Price: $2.00 
Posted:
17 Aug 2006 22:25 PDT
Expires: 16 Sep 2006 22:25 PDT Question ID: 757236 
I can't figure out how to get this to work. I am using a dollar figure of $502.15 I am then taking a percent of that figure and rounding it to display whole dollar and cents three times. I am then adding the three totals I get and also displaying that as a dollar and cent figure. The problem I am having with the progam it's calculating the figures by adding them together not as the rounded figures displayed, but as thier actual value. Which makes the display wrong. $502.15 main number i enter $31.13 this is 6.2% of main number rounded to cents $22.09 this is 4.4% of main number rounded to cents $7.28 this is 1.45% of main number rounded to cents $60.51 this should be the three values added together, but as you can see it is a penny off. I figure is is adding the numbers together before the rounding to the cents, but I can't figure how to get it to add the displayed numbers. 31.13+22.09+7.28 = 60.50 not 60.51 

Subject:
Re: microsoft excel question
Answered By: dencoga on 18 Aug 2006 02:44 PDT Rated: 
Howdy tpopga, There are at least two Excel functions that will help you accomplish your task, and the "Tech on the Net" website covers both of them. The first option is to use: Trunc http://www.techonthenet.com/excel/formulas/trunc.php "In Excel, the Trunc function returns a number truncated to a specified number of digits."  In your example, you can set cell A1 to: $502.15  In A2 you would place: =A1*0.062  In A3 you would place: =A1*0.044  In A4 you would place: =A1*0.0145  In A5 you would place: =Trunc(Sum(A2:A4),2) Alternatively, you could do the following.  In your example, you can set cell A1 to: $502.15  In A2 you would place: =Trunc(A1*0.062,2)  In A3 you would place: =Trunc(A1*0.044,2)  In A4 you would place: =Trunc(A1*0.0145,2)  In A5 you would place: =Sum(A2:A4) The ending ",2)" tells Excel to truncate the numbers to 2 places after the decimal point. The second option is to use: RoundDown http://www.techonthenet.com/excel/formulas/rounddown.php "In Excel, the RoundDown function returns a number rounded down to a specified number of digits." RoundDown is used in a similar way as "trunc" is used.  In your example, you can set cell A1 to: $502.15  In A2 you would place: =A1*0.062  In A3 you would place: =A1*0.044  In A4 you would place: =A1*0.0145  In A5 you would place: =RoundDown(Sum(A2:A4),2) Alternatively, you could do the following.  In your example, you can set cell A1 to: $502.15  In A2 you would place: =RoundDown(A1*0.062,2)  In A3 you would place: =RoundDown(A1*0.044,2)  In A4 you would place: =RoundDown(A1*0.0145,2)  In A5 you would place: =Sum(A2:A4) If you need any clarification, please feel free to ask. Search strategy: Personal experience. Looking Forward, dencoga  Google Answers Researcher 
tpopga
rated this answer:
and gave an additional tip of:
$1.00
thanks for your quick and useful help. 

Subject:
Re: microsoft excel question
From: dencoga on 19 Aug 2006 15:49 PDT 
My pleasure, tpopga, and much thanks for the 5 star rating and tip! Looking Forward, dencoga  Google Answers Researcher 
If you feel that you have found inappropriate content, please let us know by emailing us at answerssupport@google.com with the question ID listed above. Thank you. 
Search Google Answers for 
Google Home  Answers FAQ  Terms of Service  Privacy Policy 