mathematical operators

Mathematical operators are essential tools for anyone working with Excel. They are used to perform calculations and mathematical operations within worksheet cells. It is important to know the main operators and how to use them correctly to obtain the desired results.

Arithmetic Operators

Arithmetic operators are used to perform basic mathematical operations such as addition, subtraction, multiplication, and division.

• Sum (+): used to add values. Example: =A1+B1.
• Subtraction (-): used to subtract values. Example: =A1-B1.
• Multiplication (*): used to multiply values. Example: =A1*B1.
• Division (/): used to divide values. Example: =A1/B1.

Comparison Operators

Comparison operators are used to compare values ​​and return a true or false result.

• Equals (=): used to compare whether two values ​​are equal. Example: =A1=B1.
• Different (<>): used to compare if two values ​​are different. Example: =A1<>B1.
• Greater than (>): used to compare if one value is greater than another. Example: =A1>B1.
• Less than (<): used to compare whether one value is less than another. Example: =A1
• Greater or equal (>=): used to compare if one value is greater than or equal to another. Example: =A1>=B1.
• Less than or equal to (<=): used to compare whether one value is less than or equal to another. Example: =A1<=B1.

Logical operators

Logical operators are used to combine results of comparisons and return a true or false result.

• AND (AND): used to combine two or more conditions and return true if all conditions are true. Example: =AND(A1>B1, A1>C1).
• Or (OR): used to combine two or more conditions and return true if at least one of the conditions is true. Example: =OR(A1>B1, A1
• No (NOT): used to invert the result of a comparison. Example: =NOT(A1>B1).

With the knowledge of these operators, it is possible to perform complex calculations and comparisons within Excel. It is important to remember to correctly use parentheses to define the order of precedence of operations.

Next page of the Free Ebook:

8date and time functions

2 minutes