Addition in Excel. Help!

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
G

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 !
 
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
 
Back
Top