View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default 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?