Basic Excel Formulae

Hello, there welcome guys. Your excel expert Brian here. I am flooded with messages related to excel formula list. So today I thought of giving you with basic excel formulae that most people use. These formulae can be used for various applications.

Basic Arithmetic Operations

1. Addition
   • Formula: =A1 + B1
   • Description: Adds the values in cells A1 and B1.
2. Subtraction
   • Formula: =A1 - B1
   • Description: Subtracts the value in B1 from the value in A1.
3. Multiplication
   • Formula: =A1 * B1
   • Description: Multiplies the values in cells A1 and B1.
4. Division
   • Formula: =A1 / B1
   • Description: Divides the value in A1 by the value in B1. Remember, you cannot divide by zero.
5. Percentage
   • Formula: =A1 * (B1/100)
   • Description: Calculates the percentage (B1) of a number (A1).

Aggregating Data

6. SUM
   • Formula: =SUM(A1:A10)
   • Description: Adds up all the numbers in the range A1 through A10.
7. AVERAGE
   • Formula: =AVERAGE(A1:A10)
   • Description: Calculates the average of the numbers in the range A1 through A10.
8. MAX
   • Formula: =MAX(A1:A10)
   • Description: Returns the largest number in the range A1 through A10.
9. MIN
   • Formula: =MIN(A1:A10)
   • Description: Returns the smallest number in the range A1 through A10.

Rounding Numbers

10. ROUND
    • Formula: =ROUND(A1, num_digits)
    • Description: Rounds a number (A1) to a specified number of digits (num_digits).
11. ROUNDUP
    • Formula: =ROUNDUP(A1, num_digits)
    • Description: Rounds a number (A1) up, away from zero, to a specified number of digits (num_digits).
12. ROUNDDOWN
    • Formula: =ROUNDDOWN(A1, num_digits)
    • Description: Rounds a number (A1) down, towards zero, to a specified number of digits (num_digits).

Working with Powers and Roots

13. POWER
    • Formula: =POWER(number, power)
    • Description: Returns the result of a given number raised to a specific power.
14. SQRT
    • Formula: =SQRT(number)
    • Description: Returns the square root of a specified number.

Miscellaneous

15. ABS
    • Formula: =ABS(number)
    • Description: Returns the absolute value of a number, which is the number without its sign.
16. MOD
    • Formula: =MOD(number, divisor)
    • Description: Returns the remainder after a number is divided by a divisor.