ComboBox error/bug

G

Guest

The following outlines my dilema and absolute puzzlement
with Excel (verison 2002, running on Windows XP)

combobox value 0.4 is selected (linkedcell A13 from
ComboBox1)

....and is put through the following tests:
(when A13 = 0.4)

=A13 - 0.5 = -0.1 (no problem with this answer)
=A13>0.5 = Excel returns the value TRUE(?!) shouldn't this
be FALSE
=A13<0.5 = Excel returns the value FALSE (?!) shouldn't
this be TRUE

This problem only occurs when the value in A13 is less
than 0.5 AND when the value is recevied from a combobox.
When the value is directly input into the cell (A13), then
the logical tests work properly. Any idea on what the
problem might be?

Thanks!
 
F

Frank Kabel

Hi
see your other post. Your values are probably stored as text. One
workaround:
=--A13>0.5

or
=VALUE(A13)>0.5
 
G

Guest

Frank,

Thanks again!!!

Chris

-----Original Message-----
Hi
see your other post. Your values are probably stored as text. One
workaround:
=--A13>0.5

or
=VALUE(A13)>0.5


--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
Top