# 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.