| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if or statements to get three possible outcomes
I want to use an IF/OR statement to get 3 possible outcomes for a cell value
(eg if cell a=x or y, then m, if cell a=y then n, else p However, I can only work it for 2 different outcomes. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if or statements to get three possible outcomes
=IF(A1="x","m",IF(A1="y","n","p))
"Dorothy A" wrote: I want to use an IF/OR statement to get 3 possible outcomes for a cell value (eg if cell a=x or y, then m, if cell a=y then n, else p However, I can only work it for 2 different outcomes. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if or statements to get three possible outcomes
It's hard to tell what you really want, as there appears to be a
type-o......here's my interpretation................ =IF(OR(A1=X1,A1=Y1),M1,IF(A1=Z1,N1,P1)) Vaya con Dios, Chuck, CABGx3 "Teethless mama" wrote in message ... =IF(A1="x","m",IF(A1="y","n","p)) "Dorothy A" wrote: I want to use an IF/OR statement to get 3 possible outcomes for a cell value (eg if cell a=x or y, then m, if cell a=y then n, else p However, I can only work it for 2 different outcomes. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if or statements to get three possible outcomes
maybe confused am I.
=if(AND(A1=X,X=Y),M,if(A1=Y,N,P)) substitute X,Y with nubers ;M,N,P with nubers or "text". -- ***** birds of the same feather flock together.. "CLR" wrote: It's hard to tell what you really want, as there appears to be a type-o......here's my interpretation................ =IF(OR(A1=X1,A1=Y1),M1,IF(A1=Z1,N1,P1)) Vaya con Dios, Chuck, CABGx3 "Teethless mama" wrote in message ... =IF(A1="x","m",IF(A1="y","n","p)) "Dorothy A" wrote: I want to use an IF/OR statement to get 3 possible outcomes for a cell value (eg if cell a=x or y, then m, if cell a=y then n, else p However, I can only work it for 2 different outcomes. Any ideas? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if or statements to get three possible outcomes
maybe confused am I.
=if(AND(A1=X,X=Y),M,if(A1=Y,N,P)) substitute X,Y with nubers ;M,N,P with nubers or "text". -- ***** birds of the same feather flock together.. "CLR" wrote: It's hard to tell what you really want, as there appears to be a type-o......here's my interpretation................ =IF(OR(A1=X1,A1=Y1),M1,IF(A1=Z1,N1,P1)) Vaya con Dios, Chuck, CABGx3 "Teethless mama" wrote in message ... =IF(A1="x","m",IF(A1="y","n","p)) "Dorothy A" wrote: I want to use an IF/OR statement to get 3 possible outcomes for a cell value (eg if cell a=x or y, then m, if cell a=y then n, else p However, I can only work it for 2 different outcomes. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF statements or a better method ? | Excel Discussion (Misc queries) | |||
| 2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Linear Mode
