How To Software Rounding Numbers Up in Google Spreadsheets Share Pin Email Print Software Spreadsheets Documents Presentations Desktop Publishing Graphic Design Databases Animation & Video by Ted French Updated January 17, 2018 The image to the left displays examples and gives explanations for a number of results returned by Google Spreadsheets' ROUNDUP function for data in column A of the worksheet. The results, shown in column C, depend upon the value of the count argument - more information below. 01 of 02 Google Spreadsheets' ROUNDUP Function Google Spreadsheets ROUNDUP Function Examples. © Ted French Round Numbers Up in Google SpreadsheetsThe image above displays examples and gives explanations for a number of results returned by Google Spreadsheets' ROUNDUP function for data in column A of the worksheet.The results, shown in column C, depend upon the value of the count argument - more information below.The ROUNDUP Function's Syntax and ArgumentsA function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.The syntax for the ROUNDUP function is:= ROUNDUP ( number, count )The arguments for the function are:number - (required) the value to be roundedThis argument can contain the actual data for rounding or it can be a cell reference to the location of the data in the worksheet.count - (optional) the number of decimal places to leaveif the count argument is omitted, the function rounds the value up to the nearest integerif the count argument is set to 1, for example, the function leaves only one digit to the right of the decimal point and rounds it up to the next numberif the count argument is negative, all decimal places are removed and the function rounds up that number of digits to the left of the decimal point upwardfor example, if the value of the count argument is set to -1, the function will remove all digits to the right of the decimal point and round the first digit to the left of the decimal point up to 10 - example 3 in the image aboveif the value of the count argument is set to -2, the function will remove all digits to the right of the decimal point and round the first and second digits to the left of the decimal point up to 100 - example 5 in the image aboveROUNDUP Function SummaryThe ROUNDUP Function:is used to reduce a value by a specific number of decimal places or digits;will always round the rounding digit upward;alters the value of the data in the cell - unlike formatting options that allow you to change the number of decimal places displayed without actually changing the value in the cell;affects the results of calculations due to this change in data.always rounds away from zero. Negative numbers, even though they are decreased in value by the function, are said to be rounded up (examples 4 and 5 in the image above). 02 of 02 Google Spreadsheets' ROUNDUP Function Step by Step Example Google Spreadsheets' ROUNDUP Function Example. © Ted French Example: Using the ROUNDUP Function in Google SpreadsheetsAs seen in the image above, this example will use the ROUNDUP function to reduce the number in cell A1 to two decimal places. In addition, it will increase the value of the rounding digit by one.To show the effect rounding numbers has on calculations, both the original number and the rounded one will then be multiplied by 10 and the results compared.Entering the DataEnter the following data into the designated cells. Cell Data A1 - 242.24134 B1 - 10Entering the ROUNDUP FunctionGoogle Spreadsheets does not use dialog boxes to enter a function's arguments as can be found in Excel. Instead, it has an auto-suggest box that pops up as the name of the function is typed into a cell.Click on cell A2 to make it the active cell - this is where the results of the ROUNDUP function will be displayedType the equal sign ( = ) followed by the name of the function roundupAs you type, the auto-suggest box appears with the names of functions that begin with the letter RWhen the name ROUNDUP appears in the box, click on the name with the mouse pointer to enter the function name and open round bracket into cell A2Entering the Function's ArgumentsWith the cursor located after the open round bracket, click on cell A1 in the worksheet to enter that cell reference into the function as the Number argumentFollowing the cell reference, type a comma ( , ) to act as a separator between the argumentsAfter the comma type a one "2 " as the count argument to reduce the number of decimal places for the value in A1 from five to threeType a closing round bracket " ) " to complete the function's argumentsPress the Enter key on the keyboard to complete the functionThe answer 242.25 should appear in cell A2When you click on cell A2 the complete function = ROUNDUP( A1 , 2 ) appears in the formula bar above the worksheetUsing the Rounded Number in CalculationsIn the image above, the value in cell C1 has been formatted to display only three digits to make the number easier to read.Click on cell C1 to make it the active cell - this is where the multiplication formula will be enteredType an equal sign to begin the formulaClick on cell A1 to enter that cell reference into the formulaType an asterisk ( * ) - the symbol for multiplication in Google SpreadsheetsClick on cell B1 to enter that cell reference into the formulaPress the Enter key on the keyboard to complete the formulaThe answer 2,422.413 should appear in cell C1Type the number 10 in cell B2Click on cell C1 to make it the active cell.Copy the formula in C1 to cell C2 using the Fill Handle or Copy and PasteThe answer 2,422.50 should appear in cell C2.The different formula results in cells C1 and C2 - 2,422.413 vs. 2,422.50 shows the effect rounding numbers can have on calculations, which can be a significant amount in certain circumstances. Was this page helpful? Thanks for letting us know! Share Pin Email Tell us why! Other Not enough details Hard to understand Submit Continue Reading