Maybe this is a simple question
=IF(A1="y",0,"") placed in B1
=IF(A2="n",1,"") place in B2
"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
|