I would like a little help with a formula

[Jess]

Hello Folks,

I have a round up problem in a simple formula. I do not want the
answer to round up more than 3 places. I am calculating the cost of
something including taxes and for some reason the formula wants to
round up when it shouldn't and add $0.01 to the answer.

Cells: v23 to v27 are taxable amounts

Cells: v28 to v32 non taxable amounts

Cell N36 = 6.50% taxes

Cell N41 = 10% down payment

V23 = $3482.73
V24 = $752.55

V28 = $3,000
V32 = $25.00

V34 = Taxable total (=SUM V23:V27) $4235.28 (4,235.280000)

V35 = non taxable total (=SUM v28:V32) $3025.00 (3025.000000)

V36 = Taxes (=N36*V34) = $275.29 (275.293200)

V38 = TOTAL (=SUM V34:V36) $7,535.57 (7,535.573200)

V43 = DEPOSIT (=V38*N41) $753.56 (753.557320)

V45 = TOTAL DUE (=V38-V41) $6,782.02 Should be $6,782.01
(6782.015880)

All cells to formatted to 2 decimal places. I formatted to 6 decimal
places to see the whole number in ( ).

How do I fix this so the total due will have the correct answer and we
don't round up $0.01?

Thanks............. Jess

 

[Pete_UK]

Follow this link:

http://www.mcgimpsey.com/excel/pennyoff.html

It should give you some tips.

Pete

 

[Jess]

Pete,

Thank You! That did the trick.

Jess

 

[Pete_UK]

I'm glad it worked for you - thanks for feeding back.

Pete