IF and RIGHT Formula?

[Dazzawm]

I think I need an IF & RIGHT formula please. I have like below where I need the formula to say if the last 2 letters are LH or RH then the number 1, if there is nothing then the number 2. Thanks

[TABLE="width: 190"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Suspension Arm-LH[/TD]
[/TR]
[TR]
[TD]Suspension Arm-RH[/TD]
[/TR]
[TR]
[TD]Ball Joint[/TD]
[/TR]
</tbody>[/TABLE]

 

[philwojo]

Try this:

=if(or(right(a1,2)="LH",right(a1,2)="RH"),1,2)

 

[Dazzawm]

Thanks it still resulted with number 1 when there was no LH/RH on the end?

Excel 2010
	A	B
1	FAI Suspension Arm-LH	1
2	FAI Suspension Arm-RH	1
3	FAI Ball Joint	1
Sheet2

Cell Formulas
Range	Formula
B1	=IF(OR(RIGHT(A1,2)="LH",RIGHT(A1,2)="RH"),1,2)
B2	=IF(OR(RIGHT(A2,2)="LH",RIGHT(A2,2)="RH"),1,2)
B3	=IF(OR(RIGHT(A3,2)="LH",RIGHT(A3,2)="RH"),1,2)

 

[philwojo]

It worked for me on my test. If the cell (A1) was blank or didn't end in LH or RH I received a 2.

What cell are you comparing it too and what is currently in that cell?

 

[Scott T]

Evaluate the formula, on the Formulas tab under formula auditing, Evaluate Formula. This should show you what is giving you to false TRUE.

 

[philwojo]

In Cell C1 put this and tell us the results

=right(a1,2)

 

[Dazzawm]

Thanks Scott yours does not work either. If you look at A3 in #3 it does not have LH/RH at the end so should get a 2. It gives a 1?

 

[Dazzawm]

LH

 

[philwojo]

Sorry meant C3 and A3 for my test.

 

[Dazzawm]

Sorry meant C3 and A3 for my test.

LH?