The only extra work for this method is adding an additional cell below the data table. You will have to apply the SUM function and the ROUND function separately. Alternative Way #1: Using the SUM function and Round Function Separately You can also use the Decrease Decimal command to adjust the number of decimal places after the decimal point. Note: You may think the digits after the decimal is. The total price of all the grocery items is $777.0600. 2 refers that you want to keep 2 digits after the decimal point.Step_3: Press ENTER to insert the formula. Surely the easiest way to round a formula having the SUM function is to use both the ROUND function and SUM function in a single formula. Quickest Way to Round a Formula with SUM Function And, at the bottom of the data table, there is an empty cell ( B9) for calculating the Total Price. The dataset has a list of a few grocery items ( column A) and their prices ( column B) beside them.

Here is the dataset that I am going to use for this article. Alternative Way #3: Apply the ROUNDDOWN Function to Round Formula in Excel with SUM Function.Alternative Way #2: Apply the ROUNDUP Function to Round Formula with SUM Function.Alternative Way #1: Using the SUM function and Round Function Separately.Quickest Way to Round a Formula with SUM Function.No platform confusion, no unintelligible symbols - just a clear list of shortcuts to make you faster. To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC. But often, it can be hard to remember these hotkeys - especially if you regularly switch between the Mac and PC versions of Excel.

Excel shortcut keysĮxcel shortcut keys can greatly improve your speed when conducting analysis. By submitting this information, you agree to Deskbright's privacy policy and terms of service.

Formula pdf excel shortcut keys