Validation List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zainuddin Zakaria - 05 Sep 2005 17:18 GMT

I want to create a validation list for some cells in a row so that users can
only type in number 0 to 100 and also the alphabet "TH" for absentees. What
is the formula in the validation list. TQ.

Reply to this Message

Earl Kiosterud - 05 Sep 2005 17:45 GMT

Zainuddin,

If it's column A, and A1 is active (white), then you could use Data -
Validation - Custom. It will allow TH or th.
=OR(AND(B1>=0, B1 <=100),B1="TH")

The formula above will allow fractional numbers (like 34.6). If they're to
be disallowed, use:
=OR(AND(C1>=0, C1 <=100,IF(ISNUMBER(C1),MOD(C1,1),FALSE)=0),C1="TH")

--
Earl Kiosterud
www.smokeylake.com

> I want to create a validation list for some cells in a row so that users
> can
> only type in number 0 to 100 and also the alphabet "TH" for absentees.
> What
> is the formula in the validation list. TQ.

Reply to this Message