When it comes to statistics, Excel has become our best ally. And is that this program, although it was founded years ago, it has remained in the ranking of the best for its easy handling. That is why today you will learn to round decimals down in Excel automatically.
First, this program consists of a spreadsheet made up of a series of cells. There you can work with numbers in a simple wayand do math right away.
Use formulas to round down in Excel
There are several ways to round, one is rounded to the nearest number, another is rounded up and finally down. In the case of wanting to round down, the = ROUND function must be applied. Next we will talk a little about this and the other functions to round.
The method that we will teach you this time is called rounding, to use it we will write the word ‘= redondo’ right in the column next to our decimal.
Then, we select the option ‘= round.minus’. After this we open a parenthesis and we click on the number to modify, we add ';’ and we choose the number of decimal places that we want to decrease.
To finish we press the enter key and this command will be applied immediately to the selected cell. In a more graphical way our function should be So: = round minus (C4; 1).
This function allows us to reduce the time dedicated to our work and makes it easier for us in one way or another mathematical calculations using formulas that Excel contains.
What are functions used for in Excel?
Functions are the foundation of Microsoft Excel, thanks to them we can apply any kind of mathematical expression very easily. The best thing about functions is that it is usually enough to write them to perform complex processes in an instant.
Learn how to use the = ROUND function ()
Rounding is useful when decimals are not required. It's easy to use, but has its variants, so we will introduce you to the different functions for this purpose.
= ROUND ()
The rounding function is used precisely to round a number and zoom to the nearest integer. It is useful when we do not want to use decimals or when they are not important.
= ROUND ()
The ROUND function will seek to bring the number to the nearest superior. It is practically the same as ROUND, only that the function will focus on bringing the number to the highest integer.
= ROUND ()
ROUNDING is the same as ROUNDING, but in reverse, instead, This function will take the number to the lowest integer.
Try other ways to round in Excel
As we pointed out, there is not just one function to round. In fact, it is recommended to use each of them. for each particular case. For example, if you need to take a decimal to the top number, it is better to use ROUNDUP, while if you want to do the opposite, ROUNDLESS is the option.
On the other hand, if you want the most mathematical result and close to reality, then use basic ROUND function. Anyone can be helpful depending on the case. At the same time, we have other ways of rounding, the manual forms.
Using the Decimal Increase and Decrease Buttons
Decimal Increase and Decrease buttons are located on the Home tab of Excel. With them you can increase the number of decimals expressed, note that they only work when you select the cells, otherwise, using the buttons will have no effect.
Set up and apply a cell format
This is the basic way to round, to do this, just select all the cells where you want to apply the format. later, go to 'Home’In the middle you will see the format section, you can find it because it is configured as' General’ default.
To apply specific settings, just select the option that best suits your needs. This way you can apply the format and round many cells automatically.
What is Excel?
It is a Microsoft application, and its main objective is make and facilitate calculations. In it you can make calculations, formulas, math operations and you can even calculate a price table. It does not matter your occupation or profession, this program is easy to use and will help you manage your data.
In the same way, allows us to choose different designs from which you can select the one that best suits your personality or objective pursued.
It also has the style table options, where you can select the rows / columns you want to hide or show.
This has become almost indispensable in large companies, as it is compatible with various programs. In summary this is a giant calculator that facilitates the interpretation of your data.
Why use Excel?
The main reason is that it allows us, believe it or not, obtain a much higher value in our curriculum synthesis. Because The 90% of companies use this software. therefore, its use is essential when hiring new people
In addition to being a completely free and easily accessible system, it has an infinity of functions that go from a database to the creation of graphics with texts. It also allows you to improve your presentations by showing your results., what will make reading easier of large amounts of information.
And if you are a business owner, This is the program you've been looking for so long! to graphically organize your finances. It also has conditional formatting and data validation.
Y like little, It allows use user-created formulas that suit your needs, thus enhancing your business. And thus generating a much more successful company.
Excel tricks
Change the time of auto-save of our document, in some cases it is usually quite stormy when our PC gets stuck and we lose all the information we had captured.
In case you didn't know, Excel automatically saves a copy of the document, which by default is 10 minutes. You can edit this in option File> Choices> Keep.
We are located in the box that says ‘Save information every’ and we click on the tab 1 minute. We select Apply and that's it, this will no longer be a problem.
Another trick of this system is to be able to perform an advanced search with wildcard characters with the Ctrl key combination + B.
A box will immediately open where we can search for a text or a number found in our spreadsheet.
We don't necessarily have to place the whole word or number, if the case were that we do not remember it completely This option allows us to place only the word or sign that we remember. And it will immediately give us all the results available in the document.
