How to Add and Round in One Function in Microsoft Excel

1). Identify the functions you will combine into a single formula. To add numbers in Excel, use the "sum()" function. To round numbers, use the "round()" function.
2). Note the location of cells containing data you wish to add and round. For example, consider that cells A1 and A2 each contain numbers. You may wish to add these numbers together and round the final result.
3). Click in the cell where you wish to create the formula.
4). Type an equal sign ("=") to begin the formula. Complete the first part of this formula by typing "sum(a1:a2)". (Quotation marks are excluded from the actual formula.) Press the Enter key to run the formula.
5). Double-click on the same formula cell to edit it. Enclose the entire formula, except the opening equal sign, in parentheses.
6). Type the word "round" at the beginning of the first parenthesis and after the equal sign.
7). Move the cursor to the end of the formula using the right arrow key. Stop before the final ending parenthesis.
8). Type a comma.
9). Type a number after the comma that corresponds to the number of digits to which you wish to round the result. The number 0 will round the result to the nearest whole number; the number 1 will round to the first decimal place. Each decimal place farther to the right of the decimal is an increment of 1.
10

Press Enter. The previous sum displayed by the addition formula is now rounded.