1. Registered User
Join Date
Nov 2003
Posts
2

I see that there is a function for round off in excell, but I was wondering why Excell does not always round off to the higher number when there are no decimals entered into the currecny format. This can be frustrating when I'm working with complex spreadsheets with information displayed in different ways. The different sheets have the same numbers, but the data is displayed or shown differently. What happens is that I end up a dollar off, and when I change the currency format to show the 2 decimals I see why. One of the numbers did not round off to the higher ( after.5) number.
Why is thsi?
Ed

2. Registered User
Join Date
Oct 2003
Posts
1,091
Excel goes by what is stored in the cell, not how it is displayed.

3. Registered User
Join Date
Nov 2003
Posts
2

## Excell round-off

I think I understand your response, but I don't think you fully understood my issue.
A series of (stored) cells total \$8999.54
When I take the two decimals off the currency formating, I get (sometimes) \$8999, but I should get \$9000. Sometimes it does properly round off to the higher number like it should but sometimes it does not.
Why?
Ed

4. Registered User
Join Date
Oct 2003
Posts
1,091
Okay, sorry, I didn't fully understand your issue, and still not sure if this will help.

There might be four issues:

1. The distinction between display "rounding" (a formatting problem) and actual round function. Try = Round(\$8999.54,0) to see what you get.

2. Excel does not round numbers like mathematicians do (After all those many years-ago lessons on the proper way to do it in my head!), which had been confusing for me until I realized the difference.

3. Sometimes when you have two stored values, say \$220.45 and \$300.48 which would round to \$220 and \$300 respectively. If you were to add them, you would get \$520.83 rounded to \$521, but adding the two rounded numbers would give \$520.

4. How do you have the cell formatted? General, Number, Text, Custom?

Still not sure if this helps.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•