Data Validation
 

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

Thanks,
JC


--
john5079
------------------------------------------------------------------------
john5079's Profile: http://www.excelforum.com/member.php...o&userid=24526
View this thread: http://www.excelforum.com/showthread...hreadid=381234

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


Does that do what you want?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=381234

Hi,
could you not use

validation allow: whole number between 0 and 35000.

HTH


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381234

Thanks Ron..works great


--
john5079
------------------------------------------------------------------------
john5079's Profile: http://www.excelforum.com/member.php...o&userid=24526
View this thread: http://www.excelforum.com/showthread...hreadid=381234