Thread: Maybe this is a simple question
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Maybe this is a simple question
On Tue, 6 Feb 2007 20:45:56 +0800, "www" wrote:

Hi Ron,

If I want to set it as follows,

If A1 cell is Y or N, and I would like to set B1 as Y=0 or N=1.

Thanks again.
www


B1: =IF(A1="Y",0,IF(A1="N",1,"undefined"))


--ron
Reply With QuoteReply With Quote