The Comparisons guide
A comparison is a formula on its own: =C2>=500 shows TRUE when C2 is 500 or more and FALSE otherwise. Text goes in quotes, =B2="Paid", and capitals don't matter.
The comparison operators
| Operator | Meaning | Example |
|---|---|---|
= | equal to | =B2="Paid" |
<> | not equal to | =B2<>"Paid" |
> / < | more than / less than | =C2>500 |
>= / <= | at least / at most | =C2>=500 |
The first = starts the formula; the second one compares. Excel has no !=: "not equal" is <>.
Text and capitals
=B2="Paid" is TRUE for Paid, PAID and paid: comparisons ignore capitals. When capitals matter, use EXACT(B2,"Paid"). A space at the end does count, so "Paid " is not "Paid".
Numbers and text don't mix
Excel ranks every number below any text. =C2>="500" compares a number with the text "500", so it is FALSE for every amount. Leave numbers without quotes. The same goes the other way: a number stored as text is never equal to the number.
Why TRUE and FALSE are useful
They feed straight into IF, AND and OR, filters and conditional formatting. TRUE also counts as 1 in arithmetic, so =SUM(--(C2:C9>=500)) counts the big orders.
Common mistakes
- Text without quotes.
=B2=Paidgives #NAME?. - > instead of >=. "500 or more" includes exactly 500.
- "TRUE" in quotes.
=IF(C2>=500, "TRUE", "FALSE")gives text that only looks like TRUE.
FAQ
- How do I get TRUE or FALSE in Excel?
- Write a comparison as the formula: =A2>100 or =B2="Yes". It shows TRUE or FALSE without IF.
- What is the not equal sign in Excel?
- <>. =B2<>"Paid" is TRUE when B2 is anything other than Paid.
- Is an Excel comparison case-sensitive?
- No. ="paid"="PAID" is TRUE. Use EXACT when capitals matter.
- Why is my comparison always FALSE?
- Often one side is a number and the other is text: a number in quotes, as in =C2>="500", or a number stored as text in the cell.



































































