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