Need help with Investment Spreadsheet

[cajun34]

Hi,

I've created an investment spreadsheet and have a small problem with it.

The Balance column is off 1 cent.

Example:

Column
B C D E
$100.00 28.50% $28.50 $128.50
$- 20.50% $26.34 $154.84
$- 20.30% $31.43 $186.28
$- 19.85% $36.98 $223.25

Where the balance (column E) is $186.28, it should be $186.27 (add $154.84 + $31.43)

The formulas I'm using are:

Column D: (E5+B6)*C6
Column E: ((E5+B6)*C6)+(E5+B6)

What am I doing wrong?

cajun

[Asala42]

I think your looking at a rounding issue. This can be typical when multiplying interest rates for example. You might want to modify your D&E columns to:

Column D: =ROUND((E5+B6)*C6,2)
Column E: =ROUND(((E5+B6)*C6)+(E5+B6),2)

Then these columns should add correctly,

Adam

[ This Message was edited by: Asala42 on 2002-05-23 06:39 ]

[croweld89]

I haven't actually tested out the material, but my initial thought is rounding. Someone out there might have a formula for you to use, however, I would suggest just subtracting ".005" from the necessary cells. The problem of a plug of course is that it is not dynamic and will cause problems if you use this spreadsheet for other calculations in the future.

I hope this help get you started.
-Dave

[cajun34]

Thanks Adam.

I used those formulas and it appears to have worked.

I appreciate the fast help.

Regards,

cajun