Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
What is wrong with this function?
=IF(Recap!A1=C112,1,0) What I'm trying to do if I type in C112 into cell A1 then the selected cell which is on another worksheet in the same book is equal to 1 then if not then equal to 0. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Hi,
its treating C112 as an adress so put it in quotes. =IF(Recap!A1="C112",1,0) mike "dpal" wrote: What is wrong with this function? =IF(Recap!A1=C112,1,0) What I'm trying to do if I type in C112 into cell A1 then the selected cell which is on another worksheet in the same book is equal to 1 then if not then equal to 0. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Mike , I had tried that it didn't work. Also tried hypnes.
Even on the dialoge box it says false. "Mike H" wrote: Hi, its treating C112 as an adress so put it in quotes. =IF(Recap!A1="C112",1,0) mike "dpal" wrote: What is wrong with this function? =IF(Recap!A1=C112,1,0) What I'm trying to do if I type in C112 into cell A1 then the selected cell which is on another worksheet in the same book is equal to 1 then if not then equal to 0. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
I just recreated Mike's suggestino and it worked. Verify each charater to
make sure that it is what you think and the case is the same (C112 does not equal c112) -- Bill "dpal" wrote: Mike , I had tried that it didn't work. Also tried hypnes. Even on the dialoge box it says false. "Mike H" wrote: Hi, its treating C112 as an adress so put it in quotes. =IF(Recap!A1="C112",1,0) mike "dpal" wrote: What is wrong with this function? =IF(Recap!A1=C112,1,0) What I'm trying to do if I type in C112 into cell A1 then the selected cell which is on another worksheet in the same book is equal to 1 then if not then equal to 0. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
Mike, I got it. The format of the A1 cell was not TEXT it was on number. Once
I changed it to text it worked. Thanks "Mike H" wrote: Hi, its treating C112 as an adress so put it in quotes. =IF(Recap!A1="C112",1,0) mike "dpal" wrote: What is wrong with this function? =IF(Recap!A1=C112,1,0) What I'm trying to do if I type in C112 into cell A1 then the selected cell which is on another worksheet in the same book is equal to 1 then if not then equal to 0. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|