IF Formula

[d7]

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

 

[Ashish Mathur]

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

 

[Steven]

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

 

[Mike H]

Maybe

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

Miek

 

[NPell]

Maybe

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

Miek







- 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.

 

[NPell]

=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)

 

[Teethless mama]

=--(C1<>"No")

 

[Mike H]

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

=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.

 

[NPell]

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





- Show quoted text -

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