discuss all type of operator used in Microsoft Excel? illustrate long answer
Answers
Answer:
hope it helps..
Explanation:
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division.
Types of operators
There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
- Arithmetic operators
To perform basic mathematical operations such as addition, subtraction, or multiplication—or to combine numbers—and produce numeric results, use the arithmetic operators .
- Comparison operators
With the operators in the table below, you can compare two values. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE.
- Text concatenation operator
Use the ampersand (&) to join, or concatenate, one or more text strings to produce a single piece of text.
- Reference operators
Combine ranges of cells for calculations with these operators.
Answer:
they are arthemetic and logical
Explanation:
oh yeah thank you