Formula HELP

[bluefeather8989]

I need to make a formula that says

If A1 has a name in it then 101 if not 998

the names change from time to time so i cant be specific.

 

[rconverse]

What else would be in that cell?

 

[sulakvea]

and, is there a pre-determined set of names that A1 may contain?

 

[bluefeather8989]

What else would be in that cell?

persons first and last name only.

John Smith

it a sign in log kind of
A1 may have 1 name
A2 have another name and so on up to 32 diffrent names

A1 John Smith
A2 Chris Ling

 

[bluefeather8989]

persons first and last name only.

It a sign in log kind of
A1 may have 1 name
A2 have another name and so on up to 32 difrent names

A1 John Smith
A2 Chris Ling

If it where numbers i would do

=If (A1>1,101,998)
with A1 having 101

but they are names not numbers so this wouldn't work

 

[mgirvin]

Maybe this to check if there is text in the cell:

=IF(ISTEXT(A1),101,998)

 

[mgirvin]

If you wanted to check against the actual names, maybe this:

Excel Workbook
	A	B	C	D
1	name1	101		Names
2	1212	998		name1
3	Rad	998		name2
4				name3
5				name4
6				name5
7				name6
8				name7
9				name8
...

Cell Formulas
Range	Formula
B1	=IF(ISNUMBER(MATCH(A1,$D$2:$D$9,0)),101,998)
B2	=IF(ISNUMBER(MATCH(A2,$D$2:$D$9,0)),101,998)
B3	=IF(ISNUMBER(MATCH(A3,$D$2:$D$9,0)),101,998)

For your example the range $D$2:$D$9 would be changed to the range with the 32 names.

 

[bluefeather8989]

Maybe this to check if there is text in the cell:

=IF(ISTEXT(A1),101,998)

Dude I think this what i am looking for. Thanks a bunch