What is the use of equal sign in formula in excel
What is the use of equal sign in Excel?
Using calculation operators in Excel formulas
| Comparison operator | Meaning | Example |
|---|---|---|
| = (equal sign) | Equal to | =A1=B1 |
| > (greater than sign) | Greater than | =A1>B1 |
| < (less than sign) | Less than | =A1<B1 |
| >= (greater than or equal to sign) | Greater than or equal to | =A1>=B1 |
Why do we use =+ in Excel?
The “+” after “=” is superfluous. It is a carryover from Lotus 1-2-3, where formulas can be entered as +123+456 instead of =123+456. Excel permits that form as well. It changes the first to the latter.
What is the use of equal sign in creating a formula?
You can also create a formula by using a function, a predefined formula that simplifies entering calculations. Equal signs start all formulas. Constants, such as numbers or text values, can be entered directly into a formula. Operators specify the kind of calculation that the formula performs.