View Question
Q: microsoft excel question ( Answered ,   1 Comment )
 Question
 Subject: microsoft excel question Category: Business and Money > Accounting Asked by: tpop-ga 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```
 ```Howdy tpop-ga, 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, denco-ga - Google Answers Researcher```
 tpop-ga rated this answer: and gave an additional tip of: \$1.00 `thanks for your quick and useful help.`
 ```My pleasure, tpop-ga, and much thanks for the 5 star rating and tip! Looking Forward, denco-ga - Google Answers Researcher```