Jump to content

How to Create Excel Formulas – Amount, Less and Times

cara membuat rumus di Excel
5
(1)

Here's how to create an Excel formula for addition, subtraction and multiplication correctly. Using Excel formulas can make it easier to fill in data with automation that saves time and energy.

Working with Excel will make you familiar with basic mathematical operations, This is useful when processing numbers such as making financial reports such as sums, subtraction and multiplication.

Here are instructions on how to create a formula for the addition operation, reduction, and multiplication in the app Microsoft Excel.

Preparation

To make it easier to understand how formulas work in Excel, Create a table containing data containing numbers so that additions can be made, subtraction and multiplication. You can follow best practices for creating employee salary tables in Excel.

For example, in making 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 number of Deductions and the amount of Net Salary in the table requires several Excel formulas.

How to Create Excel Formulas

1. Addition Formula

For example, in the employee salary table, Gross Salary = Basic Salary + Allowance + Transport + Meal allowance. To do sums in Excel, You can use the plus sign " + “ (plus) or by using functions SUM.

1.1 With the SUM Function

The addition formula using the SUM function is: =SUM( [initial cell] : [end cell] ). So the formula =SUM(F2:I2).

To apply the addition formula using a function SUM in that table, do the following:

  1. on cells J2, type =SUM(
  2. highlight (click and drag) from the cell F2 up to the cell I2,
  3. 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 according to the column title.

The following screen displays using the function SUM in a cell in the table.

rumus Excel menggunakan fungsi SUM dalam tabel
excel use the SUM function in the table

The following screen displays using the SUM function on a regular cell

rumus Excel untuk penjumlahan menggunakan fungsi SUM
Excel formulas use the SUM function in regular cells

1.1 With Operator +

The Addition Formula with Operators is: = [number 1] + [number 2] + [number 3] + [number 4], then the formula example =F2+G2+H2+I2

To apply the formula for adding employee salary tables, use 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.

rumus Excel untuk penjumlahan menggunakan operator
excel for addition with operators +

2. Multiplication Formula

For example, in the employee salary table, Deductions = Gross Salary 2,5%. To do multiplication in Excel, use signs ” * ” (bintang). The formula for multiplication is = [number 1] * [number 2] . So an example of the formula =J2*2,5%

To apply the employee salary table multiplication formula, do the following:

  • on cells K2 type = (equal sign)
  • click on the cell G2, press * (star sign)
  • type 2,5% Then Enter
rumus Excel menggunakan operator perkalian
Excel formula for multiplication

3. Subtraction Formula

For example, in the employee salary table, Net Salary = Gross Salary – Piece. To perform subtraction in Excel, use a sign ” “(minus). The deduction formula is = [number 1][number 2] . So an example of the formula is =J2-K2.

To apply the deduction formula to the employee's salary table, 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
rumus Excel untuk pengurangan
Excel formula for subtraction

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

How useful is this article?

Click on a star to rate it!

Average rating 5 / 5. Total votes: 1

No sound so far! Be the first to rate this article.

We apologize that this article was not useful for you!

Let us improve this article!

Let us know how we can improve this article?