Formatting Crisis!

[Jo]

I copy/export part of an Access table into Excel 2000. I
need to compare a number in the Access table to a number
entered by the user in the Excel table. I think the
formatting is screwing this up.

For example I write IF(A2=$E$7,"yes!","NO") with A2 being
the downloaded Access cell and $E$7 the entered number in
Excel. If A2=04 (general format) and $E$7=4 (general
format), why won't it evaluate to true? I have tried
changing formats both to number but it doesn't make any
difference, either to the look of A2 or the result of the
formula.

Any ideas would be appreciated.

Thanks
Jo Jo

 

[Dan E]

Jo,

Sounds like one of your cells contains text. If A2 is formatted
as general and displays 04 it is likely this is the problemed
cell. Give this a try:

=IF(A2=TEXT($E$7,"00"),"yes!","NO")

OR

=IF(--A2=$E$7,"yes!","NO") <-- probably the better choice!

Dan E