Originally posted on May 24, 2022 @ 12:52 pm
Excel formulas are a challenging chore for users of this software. Excel Formulas are essential to help you utilise Excel more successfully. I covered the ways for inserting a formula in the previous session. In this session, I’ll show you how to use simple formulas.
The SUM formula in Microsoft Excel is the simplest basic. We may find the sum of two or more values in the cells using this formula. In Excel, every formula begins with the equals sign “=”, followed by a text formula. In Excel, the SUM function is a must-know formula.
To use this formula, use the syntax =SUM(number1, [number2],…) to provide the values to add together. Actual numbers or the number in a specific cell of the spreadsheet are the data we need to enter into the calculation. This formula is used in the following way:
=SUM(A2: H2) –Selection that sums a row’s values from A2 to AH.
=SUM(A2: A15) – Selects the values of a column from A2 to A15 and sums them.
A2: A5, A9: A15, A20) =SUM(A2: A5, A9: A15, A20) – A complex collection that sums values from A2 to A5, skips A6, A7, and A8, adds A9 to A15, and goes to A20.
=SUM(A2: A10)/5 – Demonstrates that your function may also be turned into a formula.
We can use the SUM formula to subtract many values from one another, for example “=SUM(A1, -B1, -C1)” with a negative sign before the cell whose value we want to subtract. The output of the formula is shown in the diagram below.
For subtraction, we can use the syntax “=A1-B1.” We can simply input the formula “=A1-B1-C1” to subtract multiple numbers from one another; the outcome of this command is shown in the figure below.
The AVERAGE formula simply averages data, such as the average number of owners in a certain shareholding. To use the average formula in Excel, start by entering the numbers, cells, or range of cells you want to average.
For example, “=AVERAGE (number1, number2, etc.) or =AVERAGE (Start Value: End Value)” is the formula format (B2: B15). The average of all the values or ranges of cells in the B2 to B15 cell range will be calculated with this formula. The average command is depicted in the diagram below.
The average can be calculated using the formula =SUM(B2: B15)/14). There are 14 cells in total, from B2 to B14. On number 14, the formula divides the total of B2 to B14.