rks Data Validation

[RKS]

Hi
I am entered 4 digit number in cell A2. i wnts when i entered number in cell
a2 its asked the number which catageory like abc, if a then show number*, if
b thn number show in cell number** otherwise normal number which i type.
witout selection cant go other cell. how is possible, pls help me
RKS

 

[Dave Peterson]

I bet you could do something like this, but I wouldn't.

Instead, I'd use multiple columns.

The 4 digit number goes into column A (say A2), the category goes into column B
(B2) and the results (or warning message) goes into column C (C2).

The formula in C2 would be:
=IF(A2="","",IF(B2="","Error: Please enter a category in column B",
IF(OR(B2={"a","b","c"}),B2,A2)))

You could use Data|Validation (xl2003 menus) to limit the choices in both column
A and column B.

Debra Dalgleish has some notes on data|validation starting here:
http://contextures.com/xlDataVal01.html

And you could use Format|Conditional formatting to make the error message show
up in big, bold, red letters.

Debra has some notes here:
http://contextures.com/xlCondFormat01.html

=======
ps. If the list of categories gets large, you may be better using another
formula in column C.

Maybe you could create a table somewhere and check the values that should be
used instead of the real number.