IF Statement with text
I am trying to create an if statment where if the last two characters in a
cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions? |
IF Statement with text
Try this instead:
=IF(OR(RIGHT($I5,2)="A1",RIGHT($I5,2)="A2"),"Y","" ) Hope this helps. Pete On Nov 19, 9:10 pm, JustinD wrote: I am trying to create an if statment where if the last two characters in a cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions? |
IF Statement with text
Thanks! Worked perfectly.
"Pete_UK" wrote: Try this instead: =IF(OR(RIGHT($I5,2)="A1",RIGHT($I5,2)="A2"),"Y","" ) Hope this helps. Pete On Nov 19, 9:10 pm, JustinD wrote: I am trying to create an if statment where if the last two characters in a cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions? |
IF Statement with text
One way:
=IF(OR(RIGHT($I5,2)={"A1","A2"}),"Y","") -- Biff Microsoft Excel MVP "JustinD" wrote in message ... I am trying to create an if statment where if the last two characters in a cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions? |
IF Statement with text
You're welcome - thanks for feeding back.
Pete On Nov 19, 9:31 pm, JustinD wrote: Thanks! Worked perfectly. "Pete_UK" wrote: Try this instead: =IF(OR(RIGHT($I5,2)="A1",RIGHT($I5,2)="A2"),"Y","" ) Hope this helps. Pete On Nov 19, 9:10 pm, JustinD wrote: I am trying to create an if statment where if the last two characters in a cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions?- Hide quoted text - - Show quoted text - |
IF Statement with text
=IF(OR(RIGHT(A1,2)="A1",RIGHT(A1,2)="A2"),"Y","")
Above you will find the answer to your question. Regards, "JustinD" wrote: I am trying to create an if statment where if the last two characters in a cell are A1 or A2, "Y" appears in another cell. I've tried a couple of formulas and nothing seems to be working. =IF(OR($I5="*A1",$I5="*A2"),"Y"," ") =IF($I5="*A1", IF($I5="*A2), "Y", " ") Any suggestions? |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com