IF

[Guey Lan]

The scenario as follows:-
if N7=A, 420
if N7=B, 288
if N7=C, 130
if N7=D, 126

Appreciate your help!!

 

[Teethless mama]

=IF(N7="A",420,IF(N7="B",288,IF(N7="C",130,IF(N7="D",126,""))))

 

[JMB]

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 A12 and
=VLOOKUP(N7,A12,2,0)

 

[Guey Lan]

Thanks....

=IF(N7="A",420,IF(N7="B",288,IF(N7="C",130,IF(N7="D",126,""))))

 

[Arvi Laanemets]

Hi

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