Is D8 a formula? If it is, the result is just slightly less than 1.5.

Esrei wrote:
Why does < (not equal to)not work in the formula in
Validation
EX D8<1.5

D8<1.5 does work


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html