https://macmost.com/e-1589 Since cells in Numbers are formatted in different ways, it is easy to have two cells appear to be the same, such as a date and the text name of a month. When using formulas to compare cells, the functions will often not match up these values because they are fundamentally different. You can use the bottom bar in Numbers to view the actual values of cells to see which value is actually stored in the cell.
Youtube
previous post