G
Guest
The scenario as follows:-
if N7=A, 420
if N7=B, 288
if N7=C, 130
if N7=D, 126
Appreciate your help!!
if N7=A, 420
if N7=B, 288
if N7=C, 130
if N7=D, 126
Appreciate your help!!
G
Guest
=IF(N7="A",420,IF(N7="B",288,IF(N7="C",130,IF(N7="D",126,""))))
G
Guest
Another suggestion - which could be useful if your scenario expands
=VLOOKUP(N7,{"A",420;"B",288;"C",130;"D",126},2,0)
The table could be placed in A1
2 and
=VLOOKUP(N7,A12,2,0)
=VLOOKUP(N7,{"A",420;"B",288;"C",130;"D",126},2,0)
The table could be placed in A1
2 and=VLOOKUP(N7,A1
2,2,0)
G
Guest
Thanks....
Teethless mama said:
A
Arvi Laanemets
Hi
=CHOOSE(CODE(N7)-64,420,288,130,126)
=CHOOSE(CODE(N7)-64,420,288,130,126)