Addition in Excel. Help!

[Gerard Sanchez]

Hi,

I work in a bank and I am working on a spreadsheet adds values ONLY the two
decimal places and disregard the rest.

i.e.

+29.901 -report displayed as --> 29.90
+29.902 -report displayed as --> 29.90
+29.903 -report displayed as --> 29.90
+29.904 -report displayed as --> 29.90
+29.905 -report displayed as --> 29.91
------------ ------------
=149.52 =149.51 (total from the displayed
values.)

The problem is that the customers only see up to two decimal places of the
amounts. On the example, if the customer adds these value on his calculator
what is displayed, they would get a different total from excel's total.

I realized that limiting the number of decimal places or changes the format
(general, accounting, or currency) only changes how the number is displayed
but not how excel treats the number in doing operations.

Any suggestions/solutions would be greatly appreciated !

 

[Bob Phillips]

What do you want to do? It seems like an educate the customer exercise to
me.

 

[Pete_UK]

If it is a formula that produces 29.901, 29.902 etc, then you can use:

=ROUND(your_formula,2)

to round it to 2 decimal places, then both totals would agree.

Hope this helps.

Pete