Solved

excel formula

Posted on 2013-05-11
2
285 Views
Last Modified: 2013-06-06
I an looking for an excel formula

in my xls I have a birthdate field column a, I would like column b to be

U9 if column A > 8/31/2003
U11 if column A > 8/31/2001 and < 9/1/2003
U13 if column A > 8/31/1999 and < 9/1/2001
U15 if column A > 8/31/1997 and < 9/1/1999
HS if column A < 9/1/1999
0
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 81

Expert Comment

by:byundt
ID: 39158910
You might try a formula like:
=IF(A1="","",LOOKUP(A1, DATE({0,1997,1999,2001,2003},9,1),{"HS","U15","U13","U11","U9"}))

It wasn't clear what the criteria for HS should be from the question. I assumed that it was before 9/1/1997, and that you wrote < 9/1/1999 in error.
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39158913
You could also use a VLOOKUP formula using a table in cells N1:O6 like:
Date          Category
0                  HS
9/1/1997      U15
9/1/1999      U13
9/1/2001      U11
9/1/2003      U9

The VLOOKUP formula would be:
=IF(A1="","",VLOOKUP(A1,N$2:O$6,2))

Both methods are shown in the attached file
AgeRatedQ28125399.xlsx
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question