The way around this is to use the ROUND() function. The problem comes from the fact that Excel is rounding the numbers for display purposes, but the formula for the total is adding up the actual cell contents, and then rounding the result for display. But if you are using a number format that displays only two decimals, both cells will display 1.25 and the total will show 2.51. These are convenient and can be very useful, but they can also lead to some embarrassing problems in how your numbers display.įor example if you have 1.254 in cell A1 and 1.253 in cell A2, and the total below that, you would see 2.507 as the total as long you are you are using General formatting or displaying at least 3 decimals. You can use number formats, such as the comma style or currency style, or the increase/decrease decimals buttons to control how many decimals Excel displays.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |