You could make another column and place for formulas such as =ROUND(A2,2) in each cell, and then sum those numbers. If we used this formula to round the sum of cells A1 through A2 =ROUND(SUM(A1:A2),2)end up with 2.51 for your total, just like in the original problem. Now let’s go back to the original example. Or, if you want to divide cell B2 by cell C2, and round the result to 3 decimals, you would use =ROUND(B2/C2,3). If you wanted to use the number from cell A2 and have it rounded to two decimal places, you could enter =ROUND(A2,2). In reality you would either want to round a number stored somewhere else, or round the result of a Formula. Of course nobody would do that because it would be easier to just type 1.25 to start with. You could enter a formula the formula =ROUND(1.254,2) and the result would be 1.25. It is very simple and works like this: =ROUND( what you want to round, number of decimals). 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 kommentar(er)
