How to round up an amount in Excel Online
The tabular format is one of the best for working with numeric data. Very often, it is numbers that are stored in Excel Online - numbers, amounts, lists, etc. Various functions and other editor tools make it very convenient to work with numbers. In particular, rounding is a popular and important tool, and in Excel Online you can round up, down, or both. We tell you how to do it.
Obviously, the developers of the online version of Excel could not fail to implement such an important aspect when working with numbers as rounding. Many lists and databases need to round numbers, and there is a handy tool for that.
To perform rounding, you must use one of three formulas:
"=ROUND ";"=ROUNDDOWN" ;"=ROUNDUP" .
The first formula applies automatic rounding to the number in brackets based on mathematical laws. Thus, if the last digit of a number is greater than or equal to 5, then it is rounded up; if the number is less than 4 - then to a smaller one.
The second formula always rounds any number down. Accordingly, the third always rounds the numbers up.
Information All of these functions have only two parameters, one of which, however, does not have to be specified. The first is directly the number to be rounded, or the cell containing it, and the second (optional) is the number of digits to which the number will be rounded.
How to round up a number in Excel: instructions
As you already understood, for rounding up, you must use the corresponding function - "= ROUNDUP" .
It's simple - you can enter in general only a number. The instruction looks like this:
- Open the Excel Online file in which you will round the numbers;
- In any cell, write the formula
"=ROUNDUP"; - Open the bracket and specify without quotes the number itself or the coordinate of the cell containing it;
- If you want, specify how many numbers after the decimal point you want to round the number;
Close the brackets and press the
Enter key.
Let's take an example. Let's say you need to round the number 57.401 up to 2 decimal places. In this case, the formula looks like this: "=ROUND(57.402, 2)", and the resulting value is like this: "57.41" .
The second parameter, i.e. the number of decimal places, can be negative. In this case, the digits of the whole number, up to the decimal point, will be taken into account. Consider an example: to round the number 4238 to the thousands place, you need to write the formula "=ROUNDUP(4238; -3)" . The result will be the number "5000" .
advice! If you round several numbers at once with a list, you can enter this formula in a free cell, and instead of a number, indicate the first cell of this list. Then this formula can be stretched down so that it is copied - then in each cell there will be a corresponding rounded number. It remains only to copy these numbers and paste them instead of the data initially.