On Tue, 6 Feb 2007 20:32:51 +0800, "www" wrote:

Hi all,

I would like to know how to achieve the following task.

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


A1=Y, And then I want to set B1 as 0.
A2=N, And then I want to set B2 as 1.

Thanks in advance,
newbie


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


--ron