# Formula Operators in Excel

You can use symbols known as operators to define the operation your Excel formula will accomplish. Some of these operators are mathematical operators that simply add, subtract, and multiply. Other operators allow you to perform more complex actions such as comparing values.

For example, you can determine whether an employee has met his or her quota by using a comparison operator to see if actual sales are greater than or equal to a predetermined quota.

The table lists the operators you can use in your Excel formulas.

Operator | What It Does |
---|---|

+ | The plus symbol adds two or more numeric values. |

– | The hyphen symbol subtracts two or more numeric values. |

/ | The forward slash symbol divides two or more numeric values. |

* | The asterisk symbol divides two or more numeric values. |

% | The percent symbol indicates a numeric percent. Entering a percent sign after a whole number divides the number by 100 and formats the cell as a percentage. |

& | The ampersand symbol is used to join or concatenate two or more textual values. |

^ | The carat symbol is used as an exponentiation operator. |

= | The equal symbol is used to evaluate whether one value is equal to another value |

> | The greater-than symbol is used to evaluate whether one value is greater than another value. |

< | The less-than symbol is used to evaluate whether one value is less than another value. |

>= | The greater-than symbol used in conjunction with the equal symbol evaluates whether one value is greater than or equal to another value. |

<= | The less-than symbol used in conjunction with the equal symbol evaluates whether one value is less than or equal to another value. |

<> | The less-than symbol used in conjunction with the greater-than symbol evaluates whether one value is not equal to another value. |