IF Formula
 

I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1

IF Formula
 

Hi,

You can use =if(or(C2="Yes",C2="N/A"),1,if(C2="No",0,""))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"d7" wrote in message
...
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1

IF Formula
 

if(c1="No",0,1)

IF Formula
 

Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek

"d7" wrote:

I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1

IF Formula
 

On Feb 13, 9:31*am, Mike H wrote:
Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek



"d7" wrote:
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A * * * * * * * * * * * B * * * * * * * * * *C * * * * * * * * * * D
Yes * * * * * * * * * *1 * * * * * * * * * Yes * * * * * * * * *(Formula)
No * * * * * * * * * * 0
n/a * * * * * * * * * *1- Hide quoted text -

- Show quoted text -

=IF(C1="No",0,"1")

Assuming no other entry except Yes, No or N/A will be entered.
It then will show a 0 for No, and a 1 for any other value.

IF Formula
 

On Feb 13, 12:53*pm, NPell wrote:
On Feb 13, 9:31*am, Mike H wrote:





Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek

"d7" wrote:
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A * * * * * * * * * * * B * * * * * * * * * *C * * * * * * * * * * D
Yes * * * * * * * * * *1 * * * * * * * * * Yes * * * * * * * * *(Formula)
No * * * * * * * * * * 0
n/a * * * * * * * * * *1- Hide quoted text -

- Show quoted text -

=IF(C1="No",0,"1")

Assuming no other entry except Yes, No or N/A will be entered.
It then will show a 0 for No, and a 1 for any other value.- Hide quoted text -

- Show quoted text -

Sorry, take the quotation marks off that 1.
=IF(C1="No",0,1)

IF Formula
 

=--(C1<"No")


"d7" wrote:

I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1

IF Formula
 

Why do you think it's safe to assume that?

"NPell" wrote:

On Feb 13, 9:31 am, Mike H wrote:
Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek



"d7" wrote:
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A B C D
Yes 1 Yes (Formula)
No 0
n/a 1- Hide quoted text -

- Show quoted text -

=IF(C1="No",0,"1")

Assuming no other entry except Yes, No or N/A will be entered.
It then will show a 0 for No, and a 1 for any other value.

IF Formula
 

On Feb 13, 2:22*pm, Mike H wrote:
Why do you think it's safe to assume that?



"NPell" wrote:
On Feb 13, 9:31 am, Mike H wrote:
Maybe

=IF(OR(C1="Yes",C1="N/A",),1,IF(C1="No",0,""))

Miek

"d7" wrote:
I need an IF formula (or something)

Yes = 1, No = 0, N/A = 1. (Column A and B)
When i enter either yes, no or n/a (in column C) i want the corresponding
number to return in column D.

A * * * * * * * * * * * B * * * * * * * * * *C * * * * * * * * * * D
Yes * * * * * * * * * *1 * * * * * * * * * Yes * * * * * * * * *(Formula)
No * * * * * * * * * * 0
n/a * * * * * * * * * *1- Hide quoted text -

- Show quoted text -

=IF(C1="No",0,"1")

Assuming no other entry except Yes, No or N/A will be entered.
It then will show a 0 for No, and a 1 for any other value.- Hide quoted text -

- Show quoted text -

Well, if anything otherwise applies - then 'd7' can use one of the
other formulas submitted.