| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
The scenario as follows:-
if N7=A, 420 if N7=B, 288 if N7=C, 130 if N7=D, 126 Appreciate your help!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
