Formula HELP

bluefeather8989

Active Member
Joined
Nov 20, 2009
Messages
251
Office Version
  1. 365
Platform
  1. Windows
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:
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

sulakvea

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

bluefeather8989

Active Member
Joined
Nov 20, 2009
Messages
251
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Nov 20, 2009
Messages
251
Office Version
  1. 365
Platform
  1. Windows

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,216
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,216
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,678
Messages
5,654,711
Members
418,149
Latest member
tjanok

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top