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

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