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