IF
 

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

Appreciate your help!!

IF
 

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


"Guey Lan" wrote:

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

Appreciate your help!!

IF
 

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


"Guey Lan" wrote:

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

Appreciate your help!!

IF
 

Thanks....

"Teethless mama" wrote:

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


"Guey Lan" wrote:

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

Appreciate your help!!

IF
 

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!!