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]

So you put this in to C3 and get LH?

[COLOR=#333333]=right(a3,2)[/COLOR]

 

[Dazzawm]

So you put this in to C3 and get LH?

[COLOR=#333333]=right(a3,2)[/COLOR]

It gave nt

 

[Dazzawm]

Should there be an 'else' formula in there also?

 

[philwojo]

Then it should be working with the formula as it is, I get the correct output of 2 when I copy and paste your data from C3 in to my test sheet.

So for "FAI Ball Joint" I get 2 as expected.

How is the data getting in to cell A3? is it typed, copied and pasted, or a formula pulling from somewhere else? Not that it should matter though.

 

[Dazzawm]

I copied the data for now.

 

[Scott T]

Select B3 and on the formulas tab select Evaluate formula. Click Evaluate and post which of the two conditions return true.

 

[philwojo]

Ok, then it should be giving you the proper output.

The IF statement gives an answer for either a "true" or "false" value, so for "True" it will give you a 1, for "false" it will give you a 2.

Your true/false test is the "OR" function in that formula and it is checking cell A3's right 2 values and testing if it is either "LH" or "RH", if it is one of those it will return "true" otherwise it gives you "false".

As I said it is working for me.

Can you press F9 on your keyboard and see if it works or not.

 

[Dazzawm]

Select B3 and on the formulas tab select Evaluate formula. Click Evaluate and post which of the two conditions return true.

I don't see anything returning true.

 

[philwojo]

Did you try and hit F9 and see if it changes that output then?

 

[Dazzawm]

It seems to be ok now, don't know what was wrong. Thanks both for your trouble.