Formula HELP

bluefeather8989

Board Regular
Joined
Nov 20, 2009
Messages
240
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.:confused:
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
and, is there a pre-determined set of names that A1 may contain?
 

bluefeather8989

Board Regular
Joined
Nov 20, 2009
Messages
240
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
 
Last edited:

bluefeather8989

Board Regular
Joined
Nov 20, 2009
Messages
240

ADVERTISEMENT

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

Well-known Member
Joined
Dec 15, 2005
Messages
1,213
Maybe this to check if there is text in the cell:

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

mgirvin

Well-known Member
Joined
Dec 15, 2005
Messages
1,213
If you wanted to check against the actual names, maybe this:
Excel Workbook
ABCD
1name1101Names
21212998name1
3Rad998name2
4name3
5name4
6name5
7name6
8name7
9name8
...
Cell Formulas
RangeFormula
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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,505
Messages
5,511,704
Members
408,861
Latest member
terrieberg

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top