# 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 (=)

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 Equal to comparison operator (=) in Excel formulas.

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 (<)

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

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 (>)

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

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 (<=)

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 Less than or equal to comparison operator (<=) in Excel formulas.

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 (>=)

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 Greater than or equal to comparison operator (>=) in Excel formulas.

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 (<>)

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 Not equal to comparison operator (<>) in Excel formulas.

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