| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
if(c1="No",0,1)
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
