Excel keeps track of data and calculates to manipulate this data. In calculations, Excel uses various formulas and these formulas include different **symbols** or operators. In this tutorial, you will learn how to insert a **sign** in an Excel formula.

## Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article.

## How to Insert 3 Types of Sign in Excel Formula

For easy discussion, we have categorized the signs (that we can input in Excel formulas) into three categories. In the following sections, we will show ways how we can use them in building various Excel formulas for different purposes.

### 1. Insert Arithmetic Signs in Excel Formula

The most common signs that we use in Excel are the arithmetic operators: **plus (+), minus (-), multiply (*),** and **divide (/).**

- Excel depicts the standard multiplication sign (x) by the asterisk (*) sign.
- The standard division sign (÷) is demonstrated by the forward-slash (/) sign.
- The caret sign (^) known as the exponential power sign raises the number to the power of another number.

The following image shows a calculation, where we are evaluating the area covered by the square in the image.

As their geometry suggests, the following formula will return the area:** (a-b) ^{2 }= a^{2}-2ab+b^{2}**

We have used both sides to generate an Excel formula for area, to show the use of ***, ^, +, and -.**

**Formula 1:**

`=C5^2-2*C5*C6+C6^2`

**Formula 2:**

`=(C5-C6)^2`

Both formulas return the same result.

**Read More: ****How to Type Math Symbols in Excel (3 Easy Methods)**

**Similar Readings**

**How to Add Currency Symbol in Excel (6 Ways)****Insert Rupee Symbol in Excel (7 Quick Methods)****How to Insert Tick Mark in Excel (7 Useful Ways)****Type Delta Symbol in Excel (8 Effective Ways)****How to Type Diameter Symbol in Excel (4 Quick Methods)**

### 2. Insert Signs as Logical Operators in Formula

MS Excel uses the following logical operators in Formula. When you use logical operators in Excel formula, it will return either **TRUE** or **FALSE.**

Signs | Explanations | Formula Examples |
---|---|---|

= | Equal to |
=B4=C4 |

<> | Not Equal to | =B4<>C4 |

> | Greater than | =B4>C4 |

< | Less than | =B4<C4 |

>= | Greater than or equal to |
=B4>=C4 |

The following screenshot shows an example of using logical operators in Excel formulas.

Formula we have used here is as follows:

`=IF(B5<18,"Child",IF(AND(B5>=18,B5<50),"Young","Old"))`

**Read More: ****Excel Formula Symbols Cheat Sheet (13 Cool Tips)**

### 3. Other Signs

You can insert more signs in Excel formula, such as: **:** (colon), **!** (exclamation mark),** []** (third bracket),** {}** (second bracket for using array), **&** (ampersand symbol), etc.

Let’s see how and why to use them in formulas.

**Curly Braces {} for Array Formula:**

**{},** curly braces are used in Excel formulas to denote an array and work with an array. In earlier Excel versions, you had to press **CTRL+SHIFT+ENTER** to enable an array formula, and after that these braces would appear before and after the formula. The following screenshot will give an idea of using these operators.

**Formula Used:**

`=TRANSPOSE(B4:C11)`

**$ (Dollar Sign), : (Colon), and Comma:**

Look at the following formula.

`=COUNTIF($B$5:$C$10, "Child")`

In this formula, the **dollar ($) sign** is used before cell reference to fix them, the colon **(:)** is used to create a data range and the comma **(,)** is used to separate the function arguments.

**Ampersand (&) and Exclamation Mark (!):**

In Excel, we use an ampersand **(&)** sign to concatenate strings in different cells. Again, an exclamation mark appears (or you can manually hard code it in the formula), when you use a cell reference from another worksheet.

Look at the following image and the formula below. You will get an idea of the way they are used.

`='First Names'!B2&" "&Others!B5`

**Third Brackets ([]):**

You have to use third brackets when you are referencing an external workbook in Excel formula.

In the following calculation, we are adding values from an External workbook, named **“Source.xlsx”,** with the following formula:

`=B5+'[Source.xlsx]Sheet1'!$B2`

Look that, a pair of third brackets appear around the file name in the formula.

**Read More: ****How to Add Symbol Before a Number in Excel (3 Ways)**

## Conclusion

In this tutorial, I have discussed how to insert signs in an Excel formula. I hope you found this article helpful. You can visit our website **ExcelDemy** to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles

**How to Insert Degree Symbol in Excel (6 Suitable Methods)****Insert Symbol in Excel Header (4 Ideal Methods)****How to Insert Symbol in Excel Footer (3 Effective Ways)****Insert square root symbol in Excel (7 easy ways)****How to Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)****Put 0 in Excel in Front of Numbers (5 Handy Methods)**