Using calculation operators in Excel formulas
Arithmetic operator | Meaning | Example |
---|---|---|
+ (plus sign) | Addition | =3+3 |
– (minus sign) | Subtraction Negation | =3–3 =-3 |
* (asterisk) | Multiplication | =3*3 |
/ (forward slash) | Division | =3/3 |
WHAT IS =@ In Excel formula?
The @ symbol is already used in table references to indicate implicit intersection. Consider the following formula in a table =[@Column1]. Here the @ indicates that the formula should use implicit intersection to retrieve the value on the same row from [Column1].
What are the 6 logical operators in Excel?
As we told you, Excel provides six logical operators to compare the data stored in an Excel sheet. These logical operators are equal, not equal, greater than, less than, greater than equal to, less than equal to. These operators work to compare the two values differently but provide either TRUE or FALSE as a result.