Combo Box error/bug?

[Chris]

This one is driving me nuts!

I have a combobox that takes list values on the worksheet
from cells A1:10. Cells A1:A10 contain the values 0.9,
0.8, 0.7... 0.0. The value selected in the combobox in
linked to cell A13.

Cell A14 takes the value selected from the combobox (Cell
A13) and subtracts 0.5. This works!

Cell A15 contains the formula : =A13>0.5. This does NOT
work for values 0.5 and lower. It returns the value of
TRUE!?!?

Cell A16 contains the formula : =A13<0.5. This also does
not work for values 0.5 and lower. It returns the value
of FALSE?!?!?

Anyone encounter this? Is this a bug?

Thanks!

 

[Frank Kabel]

Hi
but this is correct. So it is not a bug. You are doing a logical
comparisoion:
=A13>0.5
So you check if cell A13 is larger than 0.15. and if yes this formula
returns TRUE (and if not FALSE). What would be your expected result?

 

[Guest]

Frank,

I would expect the result to make sense!

I should have been a bit more detailed in my example...the
value selected in the combobox (linkedcell a13) equals
0.4. when this value is put through the logical test of
=A13>0.5, it returns TRUE. I may not be the
mathematically inclined person in the world but 0.4 is NOT
larger than 0.5.

 

[Frank Kabel]

Hi
try
=--A13>0.5

I would assume your combobox values are stored as 'Text' and not as
numbers

 

[Guest]

Thank you very much! You saved what little is left of my
sanity!!!

Chris