Help with =IF/And OR vs calculating DOB less than 18 years of Age

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

1. It does NOT have to be your real sheet - mock up a SAMPLE if you need to. But not 1000's of rows!!! It makes manual checking so tedious. Whatever you do... make sure that all confidential information is removed first!!

2. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

3. Make sure that your desired solution is also shown (mock up the results manually).

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

where is AE in your formula? You have AL but not AE.
AND, what difference does it make if the ID (in AL) is blank but one of those states is in col S?
What you want can be done, so as Glenn recommended, a sample workbook with expected results will go a long way.

I'm confused about what your results should be. Is it that you want TRUE or FALSE depending on their age with TRUE for greater than 18 and FALSE for less than 18?
And those TRUE/FALSE would be based on their ages at the date of joining? Because based on a quick check, nobody is younger than 20 years old.

plus, your formula you had... =IF(F2="",AND(OR(C2="IN",C2="KY",C2="HI",C2="WV")*TODAY()-D2/365-E2)) the multiplication is not multiplying anything.
just correcting that it should be =IF(F2="",AND(OR(C2="IN",C2="KY",C2="HI",C2="WV"),TODAY()-D2/365-E2)) which will yield different results.

you have two people with joining dates in 2035 and as best as I can tell nobody is less than 18 years of age.
we asked that you provide expected results so we can see but you just provided the workbook with your formula.
Now I'd ask that you also provide the hierarchy of the decision tree so if the states are KY and IN etc AND the ID is blank AND (or is it OR) the date of joining minus the DOB is 18 or less OR today minus the DOB is 18 or less, what happens and what happens when the states aren't those and the ID is present and today - the DOB is 18 or less OR the states aren't in your list but the ID isn't present and they are less than 18?

HI I have attached a file without the formula and what I am trying to get I am sorry this is a bit of a complicated thing for me to explain too

Hi,

Based on the temp template you've added, try this:

Formula:

Please Login or Register  to view this content.