Maybe this is a simple question

  • Thread starter Thread starter www
  • Start date Start date
W

www

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
 
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
Click to expand...

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


--ron
 
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
 
=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)
 
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
Click to expand...


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


--ron
 
www said:
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
Click to expand...

Try putting this in B1, drag down to fill as far as you need to:

=IF((OR(A1="Y",A1="y")),1,IF(OR(A1="N",A1="n"),0,"Undefined"))

This will capture a CAPS issue from data entry (I'm sure there are other
issues to "catch", but I'm no expert

Beege
 
There is no caps issue, a lower-case or upper-case letter will test the same
in a simple cell test.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Bob said:
There is no caps issue, a lower-case or upper-case letter will test the same
in a simple cell test.
Click to expand...

Thanks Bob,

I sit corrected...

Beege
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Data from One sheet to Different Sheets 1
3 simple(!?) problems: activate cell concequence / text formulas 9
Data Validation and drop-down list using IF, AND and what else? 8
cell format update problem 3
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
MATCH function not working 2
Subtracting hours and minutes with negative times 2
Conditional formatting with strcomp fails 3

Back
Top