Maybe this is a simple question
=IF(A1="Y",0,IF(A1="N",1,""))
in B1, and copy down
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"www" wrote in message
...
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
"Ron Rosenfeld"
...
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
|