Essential Excel Functions - Must-Know Calculations in Excel

Exploring Basic Calculation Functions in Excel:

1. And Function

- Syntax: And(logical1, logical2,…)

+ Where logical 1, logical 2 are conditional expressions.

+ Supports up to 256 logical expressions.

- Return Value of And Function:

+ Returns True: If all conditions are true.

+ Returns False: If there is at least one false condition.

- Value Table:

2. Or Function

- Syntax: And(logical1, logical2, …)

+ Where logical 1, logical 2, … are conditional expressions.

+ Supports up to 256 logical values.

- Return Value of Or Function:

+ Returns True: if at least one condition is true.

+ Returns False: If all conditions are false.

Value Table for Or Function:

3. Not Function

- Syntax: Not(Logical)

+ Where: Logical is mandatory.

+ Not Function is the inverse value or used in trigonometric functions.

- Return Value of Or Function:

+ Returns True if Logical has a False value.

+ Returns False if Logical has a True value.

Value Table for Not Function:

4. Sum Function

Is a function used to calculate the total of values in a cell or a list in Excel. It is a quick calculation tool.

- Syntax: Sum (value 1, value 2, ….)

+ Where: value 1, value 2 are the values to be summed.

+ Return Value: Numeric value.

- Example of using the Sum function.

We use the Sum function to calculate the net salary for employees:

Result:

5. Count Function

- Syntax: Count (value 1, value 2, …)

- Count Function is used to count the number of cells that satisfy a certain condition.

- Example of counting the number of cells with numeric values in the following table:

- Using the Count function: Syntax Count (F9:J12).

Here, I introduce some basic functions in Excel. Wish you all the best!