if function multiple conditions

[harky]

i need some help one If

If P.33 = 0.33
if P.34 = 0.34
if P.5 = 0.5
if P = 1

below is my exiting one but i wan to put as above..
=IF(G5="P", "1", "0")

 

[harky]

oh i think i found the ans.

=
IF(G5="P","1",
IF(G5="P.5","0.5",
IF(G5="P.34","0.34",
IF(G5="P.33","0.33",
"0"))))


if there is better way.. ppls let me know

 

[Cubist]

Maybe:

Book2
	A	B
1	P.33	0.33
2	P.34	0.34
3	P.5	0.5
4	P	1
5	G.54	0
Sheet2

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1="P",1,--TEXTAFTER(A1,"P",,,,0))

 

[kvsrinivasamurthy]

Try.

=IFERROR(INDEX({"1","0.5","0.34","0.33"},MATCH(G5,{"P","P.5","P.34","P.33"},0)),0)

For 365 version.
If lookup values are in G5:G9, result is required in H column then in H5 (dynamic formula)

=IFERROR(INDEX({"1","0.5","0.34","0.33"},MATCH(G5:G9,{"P","P.5","P.34","P.33"},0)),0)