Data Validation

[john5079]

I am trying to do some data entry error checking using the dat
validation custom box. I can't seem to get the syntax right. I want t
allow entry if the value the data is <C8 or = "out of service". Th
Value of C8 is 35,000..Can anyone please help?

Thanks,
J

 

[Ron Coderre]

See if this works for you (for cell A1):
Data>Validation
Allow: Custom
Formula: =OR(A1<$C$8,A1="out of service")
Click [OK]


Does that do what you want?

Ro

 

[greg7468]

Hi,
could you not use

validation > allow: whole number > between > 0 and 35000.

HTH

 

[john5079]

Thanks Ron..works grea