Validation List

  • Thread starter Zainuddin Zakaria
  • Start date
Z

Zainuddin Zakaria

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.
 
E

Earl Kiosterud

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")
 
Top