help with complex (for me) Excel formula

[Tim]

I want to enter

1 in Column a, and ft in Column b and get 1 as my answer

as well as

2 in Column a, and ft in Column b and get 0.5 as my answer

as well as

1 in Column a, and pt in Column b and get 0.5 as my answer

if anything else is enterd i need 0

so far I have got as far as

=IF(AND(OR(A1=1,A1=2),B1="ft",B1="pt"),1,0.5)

which I have entered in the cell I want the answer in

Can anyone help please

 

[Bernard Rey]

I want to enter

1 in Column a, and ft in Column b and get 1 as my answer
2 in Column a, and ft in Column b and get 0.5 as my answer
1 in Column a, and pt in Column b and get 0.5 as my answer

if anything else is enterd i need 0

One way :

=IF(OR(A12=1;A12=2)*(B1="ft"),1/A1,IF((A1=1)*
(B1="pt"),0.5,0))