Query on Logical Values

lian it wont work! if you format a cell as % and type in 50 it displays 50% but the underlying value is 0.5
thats what you have to test against. that why you either use 0.5 or 50% instead of just 50
kamalthakur
whats in the actual cells how are they formated, post a worksheet