Some basic calculation functions in Excel:
1. Ham And
- 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.
We use the Sum function to calculate food for employees:
Result:
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:
- Use the Count function: Structure of Count (F9: J12).
Above I introduced some basic functions in excel. Good luck !