FORMULA DOES NOT WORK

[Guest]

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]

Maybe it's not blank?

Tim

 

[Guest]

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

 

[GKeramidas]

sure it doesn't have a space or something in it?

yours worked, this worked, too:
=IF(ISBLANK(A1),"",A2)

 

[moon]

What happens if you use =IF(ISEMPTY(A1)=TRUE,"",A2)

 

[Nigel]

Works for me but try....

=IF(ISBLANK(A1),"",A2)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function.

 

[Guest]

if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function.

 

[Guest]

if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function.

 

[Tim Williams]

Is calculation turned on?

Tim

if i use formula audit...evaluate formula...the value, if false, does NOT
return the false value of the IF function.

 

[Guest]

One last thought. Do you have other cells linked to a1 and a2 as references?