Compare text with =
A comparison works on words as well as numbers — and ignores capital letters.
Task:
The payments export marks each invoice's status, typed by hand by three different people. In C2:C7 return TRUE when the status says paid, however it was capitalised, and FALSE otherwise.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Logical Comparisons
0/3The same formula in the other shapes it takes at work.
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Status | Paid? |
| 2 | INV-2041 | Paid | |
| 3 | INV-2042 | Overdue | |
| 4 | INV-2043 | PAID | |
| 5 | INV-2044 | Sent | |
| 6 | INV-2045 | paid | |
| 7 | INV-2046 | Part paid |
What this exercise teachesMay contain the answer
The comparison is the whole formula; there is no need to wrap it in IF just to get TRUE or FALSE back. Because = is not case-sensitive, inconsistent capitals do not matter, but anything extra in the cell does — "Part paid" is a different status, which is the right answer here.