How to create an Excel formula for addition, complete subtraction and multiplication. Using Excel formulas can make it easier to fill in data with automation that saves time and energy.
Basic mathematical operations are often encountered in daily practice for processing numbers such as making financial reports. On practice creating employee salary tables in Excel, You need a formula to find out the gross salary amount, deductions and net salary amount.
In the simulation, create an employee salary table, The gross salary is the sum of several salary components such as the basic salary, allowances and food allowance. To calculate the amount of Gross Salary, The amount of Deductions and the amount of Net Salary in the table requires an Excel formula.
Here are instructions on how to create a formula for the addition operation, reduction, and multiplication in the app Microsoft Excel.
List of contents
Addition Formula
To do sums in Excel, can use the symbol " + “ (plus) or by using functions SUM.
Simulation:
Gross Salary = Basic Salary + Allowance + Transport + Meal allowance
Formula with SUM function:
=SUM( [initial cell] : [end cell] )
Example:
=SUM(F2:I2)
Implementation:
To apply a sum formula in Excel using a function SUM, do the following:
- on cells J2, type =SUM(
- highlight (click and drag) from the cell F2 up to the cell I2,
- then press Enter.
If you are working in a table that has been declared via Format as Table or Insert Table, each cell in the table will be named with a column heading.
The following screen displays using the function SUM in a cell in the table.
The following screen displays using the SUM function on a regular cell
Formulas with Operators:
= [number 1] + [number 2] + [number 3] + [number 4]
Example:
=F2+G2+H2+I2
Implementation:
To apply the addition formula in Excel using operators + (plus sign), do the following:
- on cells J2, type sign = (equal sign)
- click a cell F2, press + (plus sign)
- click a cell G2, press + (plus sign)
- click a cell H2, press + (plus sign)
- click a cell I2 then press Enter
This method does not seem practical but is useful if the cells being added together does not allow using the function SUM
The screen display uses the addition operator.
Multiplication Formula
To do multiplication in Excel, you need to use operators * (star sign).
Simulation:
Deductions = Gross Salary 2,5%
Formula:
= [number 1] * [number 2]
Example:
=J2*2,5%
Implementation:
To apply multiplication formulas in Excel, do the following:
- on cells K2 type = (equal sign)
- click on the cell G2, press * (star sign)
- type 2,5% Then Enter
Subtraction Formula
To perform subtraction in Excel, use operators – (less sign).
Simulation:
Net Salary = Gross Salary – Piece
Formula:
= [number 1] – [number 2]
Example:
=J2-K2
Implementation:
To apply subtraction formulas in Excel, do the following:
- click on the cell L2 and type = (equal sign)
- click on the cell J2, press – (less sign)
- click on the cell K2 then press Enter
Closing
That's how to create an Excel formula for addition, subtraction and multiplication in employee salary tables. If you have followed Best Practices for Creating Tables in Excel, The formula will automatically be applied to the next row in the table. If not, You need to copy the formula and paste on each subsequent row.
After understanding how to create an Excel formula for addition, subtraction and multiplication, You can continue with Other Excel Formula Functions which is useful for increasing your work effectiveness and productivity.
Hope it is useful