ExcelBanter - FORMULA DOES NOT WORK

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - FORMULA DOES NOT WORK (https://www.excelbanter.com/excel-programming/372527-formula-does-not-work.html)

F. Lawrence Kulchar

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

Tim Williams

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

Halim

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

GKeramidas

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

moon[_6_]

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

Nigel

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

F. Lawrence Kulchar

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

F. Lawrence Kulchar

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

F. Lawrence Kulchar

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

F. Lawrence Kulchar

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

F. Lawrence Kulchar

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

F. Lawrence Kulchar

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

Tim Williams

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.

JLGWhiz

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

All times are GMT +1. The time now is 02:12 AM.