Hi

=CHOOSE(CODE(N7)-64,420,288,130,126)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Guey Lan" wrote in message
...
The scenario as follows:-
if N7=A, 420
if N7=B, 288
if N7=C, 130
if N7=D, 126

Appreciate your help!!