Basic functions in Excel - Common calculator functions that you need to know in Excel

Some basic calculation functions in Excel:

1. Ham And

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 1

- Structure: And (logiccal1, logical 2, .)

+ Where logical 1, logical 2 are conditional expressions.

+ There are up to 256 logical expressions.

- Return value of And function:

+ Return True: If all conditions carry true values.

+ Return False: If there is a condition with false value.

- Value table:

And (Logical 1, logical 2, logical 3)

Logical 1

Logical 2

Logical 3

True

True

True

True

False

False

False

True

False

False

False

False

2. The Or function

- Structure: And (logical 1, logical 2, .)

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

+ There are up to 256 logical values

- Return value of the Or function:

+ Return True: if there is at least 1 condition with true value.

+ Return False: If all conditions are false.

Table of values ​​for the Or function:

Or (Logical 1, logical 2)

Logical 1

Logical 2

Logical 3

True

True

True

True

False

True

False

True

True

False

False

False

3. The Not function

- Syntax: Not (Logical)

+ Where: Logical is required

+ Not function is the function to get the inverse value or use in trigonometric functions.

- Return value of the Or function:

+ Returns True if Logical is false.

+ Return False if Logical is true.

The value table for the Not function:

Value condition

Or magic result (Condition)

True

False

False

True

4. Ham Sum

A function that sums values ​​in cells or in a list in excel. Is a tool to help calculate quickly.

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

+ In which: value 1, value 2 are the values ​​to be calculated.

+ Return value: is the numerical value.

- Example of using Sum function.

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 2

We use the Sum function to calculate food for employees:

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 3

Result:

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 4

5. The Count function

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

- The Count function counts the number of cells that meet certain conditions.

- For example, count the number of cells with numeric values ​​in the following table:

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 5

- Use the Count function: Structure of Count (F9: J12).

Basic functions in Excel - Common calculator functions that you need to know in Excel Picture 6

Above I introduced some basic functions in excel. Good luck !