What is the use of equal sign in Excel?

Using calculation operators in Excel formulas
Comparison operatorMeaningExample
= (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.