IFS doesn't recognize value in cell.

[Romano_odK]

Good afternoon,

I am trying to make this work. The Status should be "match" but it doesn't recognize my text in cell E1. I suppose it has to do with what kind of cell this is but I do not know how to solve it.

Thank you for your time,

Romano

Book1
	A	B	C	D	E
1	31/12/2021		2021	31/12/	31/12/2021
2			2022	31/12/	31/12/2022
3	Status		2299	31/12/	31/12/2299
4	no match
Sheet1

Cell Formulas
Range	Formula
C1	C1	=YEAR(TODAY())
C2	C2	=C1+1
E1:E3	E1	=CONCAT(D1,C1)
A4	A4	=IFS(A1=E1,"match",TRUE,"no match")

 

[Joe4]

The little orangish-yellowish triangles you see up in the upper left corner of some cells in columns C and E indicate that those values are entered as Text, and not as Dates/Numbers.
So comparing Text to a Date/Number (A1=E1) will always return false.
You need to convert the values in column E to valid dates/numbers, either converting the data itself, or converting it in the formula, using something like the DATEVALUE function.

 

[Romano_odK]

Good afternoon,

I am trying to make this work. The Status should be "match" but it doesn't recognize my text in cell E1. I suppose it has to do with what kind of cell this is but I do not know how to solve it.

Thank you for your time,

Romano

Book1
	A	B	C	D	E
1	31/12/2021		2021	31/12/	31/12/2021
2			2022	31/12/	31/12/2022
3	Status		2299	31/12/	31/12/2299
4	no match
Sheet1

Cell Formulas
Range	Formula
C1	C1	=YEAR(TODAY())
C2	C2	=C1+1
E1:E3	E1	=CONCAT(D1,C1)
A4	A4	=IFS(A1=E1,"match",TRUE,"no match")

I used the Datevalue and it works perfectly. Thank you for your reply.

Kind regards,

Romano

 

[Joe4]

You are welcome.