Advances in our society have been greatly enhanced thanks to the arrival of different technologies associated with the creation of different software that have greatly simplified various aspects of our lives, reducing the time we have to dedicate to various activities , added to the guarantee that these operations were carried out successfully and safely.
One of the most important aspects occurs at the economic level, where historically the processes to keep accounts between expenses and income can result in a fairly complex process in which, by not doing the accounts well, they can lead to gigantic problems for the company . .
How to Make Automatic Multiplications in Excel – Applies in Cells and Columns
Nowadays, these problems have been minimized with the use of modern spreadsheet systems such as the popular Microsoft Excel , which allows all its users to organize a complex amount of data in a short time.
These analyzes are not a small thing, since the system has complex formulas and graphs that facilitate the statistical study, but how can we make the most of the use of this tool?
Index( )
- How to create a multiplication table in Excel?
- What are the formulas to add, subtract, multiply and divide in Excel?
- How can I multiply the selected cells?
- Multiply a column of numbers by a constant
How to create a multiplication table in Excel?
Starting with the basics, we have that Excel allows us to carry out simple operations such as subtraction and, of course, multiplication, being only necessary to have the quantity that we need to multiply, whether we add the numbers ourselves or that they are inside a cell in spreadsheet.
With the first thing that we will be able to demonstrate that these basic functionalities go far beyond what can be done with traditional tasks, it is how all the accounts can be automated using simple commands, taking as an example the case of creating a multiplication table in Excel.
For this simple procedure we have several ways to create it where the main or easiest is to do it with the following steps:
- We create a column with the numbers from 1 to 9
- In the next column to that we proceed to place the operation =N*A2,where N represents any number by which we want to repeat the multiplication and A2 the cell where the numbering begins.
- Then, in the lower right corner where this result is generated, we proceed to drag it to the cell with the number 9 and we will have a multiplication table automatically generated.
What are the formulas to add, subtract, multiply and divide in Excel?
It should be noted that, thanks to the large set of formulas that Excel has , its functions are not limited only to multiplication. For example, the COUNTIF function allows us to highlight certain data and we can even easily make histograms.
So, with Excel we can really perform operations with any arithmetic operator , with the amount of data that is necessary to handle. To carry out this process, which is really quite simple, we will only have to follow the following ways to specify the formulas in the sheet:
- Suma: ‘=A1+A2’
- Resta: ‘=A1-A2’
- Multiplication: ‘=A1*A2’
- Division: ‘=A1/A2’
For this case we will always have to start the operation with ‘=’, followed by the arithmetic operation between values that we can assign ourselves or that are in cells like A1 or A2 as in the example.
How can I multiply the selected cells?
As the tool par excellence when it comes to keeping accounts or being able to carry out a multitude of processes automatically, which we have already made quite clear above, it allows us to carry out the same process in different ways , so we will not always have the same solution. for a single problem, but we can have more or less quick solutions.
One of these is to avoid having to manually enter the numbers, but instead we can use the cells already created to do the calculations, as has been highlighted.
This is achieved when we click on the cell where the operation will be performed where, after placing ‘=’, we will proceed to select the cell with the number , we place the arithmetic operator, select the next cell and that’s it!
Multiply a column of numbers by a constant
Finally, we can have a case in which we want to multiply a column of numbers by a cell, but that this remains constant throughout the operation, for which we will follow the following pattern:
- We create the number column and place the cell in which the constant will be found
- In the first cell of the second column we will introduce the following formula: =A1+A$3
Where A1 is the first cell of the first column that contains the value of the first number, while A$3 is the cell where the constant value is, only the $ is added before the 3 so that Excel takes it as a constant value .