Question

ROUNDLESS in Excel

Answer 1

Why round down in Excel?
Syntax of the formula ROUNDLESS
Example of ROUNDLESS in Excel

---

ROUNDLESS in Excel

The Microsoft spreadsheet provides many functions that make our lives easier when performing complex calculations. The program, in addition to numerous algebra and statistics formulas, offers ROUNDDOWN, a relatively simple function to round values ​​down. This formula, one of the most basic in Excel, is as simple as it is useful and you should know how to use it correctly. We explain how..

Index

1. Why round down in Excel?
2. Syntax of the formula ROUNDLESS
3. Example of ROUNDLESS in Excel

Why round down in Excel?

A complex calculation can result in a number with many decimal places . However, we hardly ever work with these values ​​on a day-to-day basis. Both when keeping accounting and when working with percentages or units of measurement, we usually use numbers with only two decimal places. Therefore, sometimes, the most logical thing is to round the numbers down and set values ​​that are useful to us.

In Excel, there are several ways to do it. For example, many users are familiar with the option to configure cells so that a specified number of decimal places is displayed. However, this only modifies the presentation of the value, not the value itself: in reality, the underlying number remains the same, with all its decimals, even though they are not displayed. This may make sense if we want to continue calculating with that number, but sometimes it is convenient to round it down. In this case, we have to use a formula like ROUNDLESS..

advice

Excel also includes the formula for ROUNDING, which offers more rounding options. However, if you only want to round down, we recommend using the ROUNDLESS function, which is simpler and easier to use.

Syntax of the formula ROUNDLESS

The formula only consists of two parameters. On the one hand, you must specify the real number to be rounded down and, on the other, the decimals of the final value..

  =REDONDEAR.MENOS(número; núm_decimales)  

• number - This can be the real number, which can be included in the formula, or it can be a cell reference.
• num_decimals : indicates the positions to be rounded. Positive parameters refer to the decimals to the right of the comma, while negative parameters indicate the digits to the left of the comma. Again, it is possible to enter cell references.

As we can see, Excel allows rounding both whole numbers and decimals. If you use a value greater than zero for the decimals, you will indicate how many decimal places the final value has. If you specify zero , all decimals are removed. A negative value rounds the corresponding digits to the left of the comma to the next multiple of ten that is less than the number.

Note

ROUNDDOWN always rounds down: for example, 4.9 will round to 4.

Example of ROUNDLESS in Excel

The easiest way to use the ROUNDLESS function in Excel is to enter the numbers into the formula, as in the following examples:

  =REDONDEAR.MENOS(1234,5678;2) = 1234,56 =REDONDEAR.MENOS(1234,5678;0) = 1234 =REDONDEAR.MENOS(1234,5678;-2) = 1200  

Indicate the positions you want to round down.

However, it is also possible to refer to another cell to obtain the value to be rounded and thus adapt the formula to a large range of cells:

  =REDONDEAR.MENOS(A1;2)  

Using cell references, you can quickly apply the ROUNDLESS formula to many values ​​in Excel.

Applying this formula to other cells allows you to round down multiple values ​​at once. You can then use the results to perform another calculation or directly nest multiple formulas. In this way, you can add the ROUNDLESS function to another formula or incorporate the result of another calculation into the formula to round down.

  =NUMERO.ROMANO(REDONDEAR.MENOS(1234,5678;0))  

You can nest ROUNDLESS in other functions to work directly with a number rounded down.

In the following example, the formula rounds the value to a whole number, and then writes it in Roman numerals: MCCXXXIV.

  =REDONDEAR.MENOS(COCIENTE(A1;B1);-2)  

If you combine other functions with ROUNDLESS, you will get a rounded number directly.

In this example, we combine ROUNDLESS with the QUOTIENT function: Excel divides the value of the first cell by the value of the second, and finally rounds the last two digits of the result.

Done

If you try to round a number that already has fewer decimal places than indicated in the formula, nothing will happen. That is, the missing digits will not be padded with zeros. For example, if you try to round the number 5 to two decimal places, the result will still be 5. If you want the program to display? 5.00 ?, you will have to set the cell format accordingly.

---