It also includes information on using an Excel array CSE formula and using the ROUNDUP and ROUNDDOWN functions.
Then, adhere to these instructions:
Select cellB6to make it the active cell.
Select theFormulastab of theribbon.
SelectMath & Trigto pop launch the function drop-down list.
SelectROUNDin the list to pop kick open the Function Arguments dialog box.
On a Mac, the Formula Builder opens.
Place the cursor in theNumbertext box.
TypeSUM (A2:A4)to enter the SUM function as the Number argument of the ROUND function.
Place the cursor in theNum_digitstext box.
key in a2to round the answer to the SUM function to 2 decimal places.
SelectOKto complete the formula and return to the worksheet.
Except in Excel for Mac, where you selectDoneinstead.
Select cellB6to display the nested function in theformula barabove the worksheet.
Excel doesn’t allow a second dialog box to be opened when entering a formula.
These braces are not typed in, however, but are entered by pressing theShift+Ctrl+Enterkeys on the keyboard.
Because of the keys used to create them, array formulas are sometimes referred to as CSE formulas.
Array formulas are normally entered without the aid of a function’s dialog box.
bang out the formula:
Pressand hold theShift+Ctrlkeys.
The value 764.87 appears in cell B8.
Select cellB8to display the array formulain the formula bar.
They are theROUNDUPand ROUNDDOWN functions.
Prior to this version, only seven levels of nesting were permitted.
FAQ
Yes, ROUND (along with ROUNDUP and ROUNDDOWN) will also work with multiplication totals.
It’s a similar formula, except ignore “SUM” and use “*” to multiply cells.
It should look something like this:=ROUNDUP(A2*A4,2).
The same approach can also be used for rounding other functions like cell value averages.
It should look something like=ROUND(SUM(A2:A4),0).
Continue selectingIncrease Decimaluntil it displays as much of the cell’s number as you want.
