# Comparison operators in Excel

Excel comparison operators are used to compare numbers, text, contents of Cells, or result of functions. If the comparison is true, the Excel formula returns the Boolean value TRUE and if the comparison is wrong, the Excel formula returns the Boolean value FALSE.

Following table lists important comparison operators used in Excel formulas.

Comparison Operator | Description |
---|---|

= | Equal to |

< | Less than |

> | Greater than |

<= | Less than or equal to |

>= | Greater than or equal to |

<> | Not equal to |

Following sections show how comparison operators work in Excel formulas.

### Excel __Equal to__ comparison operator (=)

__Equal to__

Excel * Equal to* comparison operator (=) is used to compare whether two numbers, text, contents of Cells, or result of functions are the same. Following table shows some examples of Excel

*comparison operator (=) in Excel formulas.*

__Equal to__Equal To Comparison Operator | Description | Result |
---|---|---|

=100=100 | Compares whether number 100 is equal to number 100 | TRUE |

=100=99 | Compares whether number 100 is equal to number 99 | FALSE |

="Excel"="Excel" | Compares whether text Excel is same as text Excel | TRUE |

="Excel"="Xcel" | Compares whether text Excel is same as text Xcel | FALSE |

### Excel __Less than__ comparison operator (<)

__Less than__

Excel * Less than* comparison operator (<) is used to check whether a number is less than another number. Following table shows some examples of Excel

*comparison operator (<) in Excel formulas.*

__Less than__Less than Comparison Operator | Description | Result |
---|---|---|

=99<100 | Compares whether number 99 is less than number 100 | TRUE |

=100<99 | Compares whether number 100 is less than number 99 | FALSE |

=100<100 | Compares whether number 100 is less than number 100 | FALSE |

### Excel __Greater than__ comparison operator (>)

__Greater than__

Excel * Greater than* comparison operator (>) is used to check whether a number is greater than another number. Following table shows some examples of Excel

*comparison operator (>) in Excel formulas.*

__Greater than__Greater than Comparison Operator | Description | Result |
---|---|---|

=100>99 | Compares whether number 100 is greater than number 99 | TRUE |

=99>100 | Compares whether number 99 is greater than number 100 | FALSE |

=100>100 | Compares whether number 100 is greater than number 100 | FALSE |

### Excel __Less than or equal to__ comparison operator (<=)

__Less than or equal to__

Excel * Less than or equal to* comparison operator (<=) is used to check whether a number is less than or equal to another number. Following table shows some examples of Excel

*comparison operator (<=) in Excel formulas.*

__Less than or equal to__Less than or equal to Comparison Operator | Description | Result |
---|---|---|

=99<=100 | Compares whether number 99 is less than or equal to number 100 | TRUE |

=100<=99 | Compares whether number 100 is less than or equal to number 99 | FALSE |

=100<=100 | Compares whether number 100 is less than or equal to number 100 | TRUE |

### Excel __Greater than or equal to__ comparison operator (>=)

__Greater than or equal to__

Excel * Greater than or equal to* comparison operator (>=) is used to check whether a number is Greater than or equal to another number. Following table shows some examples of Excel

*comparison operator (>=) in Excel formulas.*

__Greater than or equal to__Greater than or equal to Comparison Operator | Description | Result |
---|---|---|

=100>=99 | Compares whether number 100 is greater than or equal to number 99 | TRUE |

=99>=100 | Compares whether number 99 is greater than or equal to number 100 | FALSE |

=100>=100 | Compares whether number 100 is greater than or equal to number 100 | TRUE |

### Excel __Not equal to__ comparison operator (<>)

__Not equal to__

Excel * Not equal to* comparison operator (<>) is used to check whether numbers, text, contents of Cells, or result of functions are not the same. Following table shows some examples of Excel

*comparison operator (<>) in Excel formulas.*

__Not equal to__Not equal to Comparison Operator | Description | Result |
---|---|---|

=100<>100 | Compares whether number 100 is not equal to number 100 | FALSE |

=100<>99 | Compares whether number 100 is not equal to number 99 | TRUE |

="Excel"<>"Excel" | Compares whether text Excel is not same as text Excel | FALSE |

="Excel"<>"Xcel" | Compares whether text Excel is not same as text Xcel | TRUE |