Data Validation

J

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
 
R

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
 
G

greg7468

Hi,
could you not use

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

HTH
 
Top