Thread: if or statements to get three possible outcomes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote