I have got the following formula that looks at a cell, and if it contains the characters "IDE" anywhere on the text then it puts a "Y" on the column, otherwise an "N".
=IF(COUNTIF(J1021, "*IDE*"),"Y", "N")
What I want to do is actually modify this formula so it only puts a "Y" on the cell if the last 3 characters of the cell are "IDE", not just a match anywhere.
That way I can have something like this.
>Solution :
Using RIGHT() Function
• Formula used in cell B1
=IF(RIGHT(A1,3)="IDE","Y","N")
You can also do a BOOLEAN LOGIC here,
• Simply enter the formula in cell C1
=(RIGHT(A1,3)="IDE")*1
And then Custom format the cell by pressing CTRL + 1 –> Format Cells –> Number Tab –> Category –> Custom –> Type –>
[=1]"Y";[=0]"N";
But note the cells will show 1 for a TRUE value & 0 for a FALSE value.