ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/20434-data-validation.html)

Esrei

Data Validation

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

D8<1.5 does work

Debra Dalgleish

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

All times are GMT +1. The time now is 11:14 PM.