All courses > Information Technology > Excel, Word, LibreOffice and more ( Office ) ::

mathematical operators

Capítulo 7

Estimated reading time: 3 minutes

+ Exercise

Listen in audio

0:00 / 0:00

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.

Continue in our app.

Listen to the audio with the screen off.
Earn a certificate upon completion.
Over 5000 courses for you to explore!

Or continue reading below...

Download the app

Now answer the exercise about the content:

_What operator is used to compare whether a value is greater than or equal to another?

You are right! Congratulations, now go to the next page

You missed! Try again.

The operator used to compare whether a value is greater than or equal to another is '>='. It is explicitly described in the text under 'Comparison Operators', stating that this operator compares if one value is greater than or equal to another, with an example provided: '=A1>=B1'.