The horizontal formula line is calculating money past two places after the
decimal point, yet showing only the two places (which is what I want to see).
The vertical formula then adds the results from the horizontal formula, but
it calculates beyond 2 places after the decimal, and causes the bottom line
figure to reflect an incorrect amount. Can this be overcome?

ToolsOptionsCalculation tab, check "Precision as displayed".
Do read HELP first to know what this does. I use this often for financial spreadsheets.


--
Kind regards,

Niek Otten

"JDueck" wrote in message ...
| The horizontal formula line is calculating money past two places after the
| decimal point, yet showing only the two places (which is what I want to see).
| The vertical formula then adds the results from the horizontal formula, but
| it calculates beyond 2 places after the decimal, and causes the bottom line
| figure to reflect an incorrect amount. Can this be overcome?

JE McGimpsey's website addresses that exact situation:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"JDueck" wrote:

The horizontal formula line is calculating money past two places after the
decimal point, yet showing only the two places (which is what I want to see).
The vertical formula then adds the results from the horizontal formula, but
it calculates beyond 2 places after the decimal, and causes the bottom line
figure to reflect an incorrect amount. Can this be overcome?

Round the invidual cells to 2 dec places (round(A1,2)) and this should
correct the problem. Third decimal place of 5 or greater will round up.

HTH

"JDueck" wrote:

The horizontal formula line is calculating money past two places after the
decimal point, yet showing only the two places (which is what I want to see).
The vertical formula then adds the results from the horizontal formula, but
it calculates beyond 2 places after the decimal, and causes the bottom line
figure to reflect an incorrect amount. Can this be overcome?