| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA DOES NOT WORK
I have the following formula typed into my cell:
=If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
Maybe it's not blank?
Tim "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
Hi,
No problem with your formula : =If(a1="","",a2) maybe your computer use semicolon not comma try use : =If(a1="";"";a2) That based on you regional setting I guess! Or try to not write the formula in A1 ... HTH, Halim -- Halim Nur Ikhwan "F. Lawrence Kulchar" wrote: I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
sure it doesn't have a space or something in it?
yours worked, this worked, too: =IF(ISBLANK(A1),"",A2) -- Gary "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
What happens if you use =IF(ISEMPTY(A1)=TRUE,"",A2)
"F. Lawrence Kulchar" schreef in bericht ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
Works for me but try....
=IF(ISBLANK(A1),"",A2) -- Cheers Nigel "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
EVEN IF I TYPE:
=if(a2=85,"A","F").. it does NOT WORK..if i change a2 to and from 85, the value in my cell remains fixed at either "A" or "F"...i.e.the formula is not working. FLKulchar "moon" wrote: What happens if you use =IF(ISEMPTY(A1)=TRUE,"",A2) "F. Lawrence Kulchar" schreef in bericht ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
EVEN IF I TYPE:
=if(a2=85,"A","F").. it does NOT WORK..if i change a2 to and from 85, the value in my cell remains fixed at either "A" or "F"...i.e.the formula is not working. FLKulchar "Tim Williams" wrote: Maybe it's not blank? Tim "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
EVEN IF I TYPE:
=if(a2=85,"A","F").. it does NOT WORK..if i change a2 to and from 85, the value in my cell remains fixed at either "A" or "F"...i.e.the formula is not working. FLKulchar "GKeramidas" wrote: sure it doesn't have a space or something in it? yours worked, this worked, too: =IF(ISBLANK(A1),"",A2) -- Gary "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function. "GKeramidas" wrote: sure it doesn't have a space or something in it? yours worked, this worked, too: =IF(ISBLANK(A1),"",A2) -- Gary "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function. "Halim" wrote: Hi, No problem with your formula : =If(a1="","",a2) maybe your computer use semicolon not comma try use : =If(a1="";"";a2) That based on you regional setting I guess! Or try to not write the formula in A1 ... HTH, Halim -- Halim Nur Ikhwan "F. Lawrence Kulchar" wrote: I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function. "Tim Williams" wrote: Maybe it's not blank? Tim "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
Is calculation turned on?
Tim "F. Lawrence Kulchar" wrote in message ... if i use formula audit...evaluate formula...the value, if false, does NOT return the false value of the IF function. "Tim Williams" wrote: Maybe it's not blank? Tim "F. Lawrence Kulchar" wrote in message ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA DOES NOT WORK
One last thought. Do you have other cells linked to a1 and a2 as references?
"F. Lawrence Kulchar" wrote: EVEN IF I TYPE: =if(a2=85,"A","F").. it does NOT WORK..if i change a2 to and from 85, the value in my cell remains fixed at either "A" or "F"...i.e.the formula is not working. FLKulchar "moon" wrote: What happens if you use =IF(ISEMPTY(A1)=TRUE,"",A2) "F. Lawrence Kulchar" schreef in bericht ... I have the following formula typed into my cell: =If(a1="","",a2) I mean: If the contents of a1 is blank, insert a blank; otherwise, insert the contents of cell a2. IT DOES NOT WORK!!!! Maybe, the format of a1 is in error; but, anyway, a blank a1 does NOT yield a blank in my cell, and vice-versa. WHAT AM I DOING WRONG?? How is this fixed? Thank you, FLKulchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| Help, I need a formula for work. | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| extract a foldername with a formula-update formula does not work | Excel Programming | |||
Linear Mode
