sdkorin
New Member
- Joined
- Feb 1, 2018
- Messages
- 22
- Office Version
- 2016
- Platform
- Windows
I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me.
I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J.
Columns I and J are for dates someone is certified in aparticular machine (I for machine “A” & J for machine “B”) or the words “noteligible” if they are not eligible to be certified in the machine. If “not eligible”is removed from both cells, but there is not date, they are eligible to becertified.
If a date goes into, say, column I, there will be nothing incolumn J, until they certify in that machine.
What I would like to do is have column H say “No” if columnsI & J either say “not eligible” or are both blank. And I was it to say “Yes”if there is a date in 1 or both of columns I & J.
The current formula I am using give me a “No” it “noteligible” is present but a “Yes” if there is a date or both cells are blank.
I really appreciate the help.
I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J.
Columns I and J are for dates someone is certified in aparticular machine (I for machine “A” & J for machine “B”) or the words “noteligible” if they are not eligible to be certified in the machine. If “not eligible”is removed from both cells, but there is not date, they are eligible to becertified.
If a date goes into, say, column I, there will be nothing incolumn J, until they certify in that machine.
What I would like to do is have column H say “No” if columnsI & J either say “not eligible” or are both blank. And I was it to say “Yes”if there is a date in 1 or both of columns I & J.
The current formula I am using give me a “No” it “noteligible” is present but a “Yes” if there is a date or both cells are blank.
Code:
=IF(I3<"1/1/1999","Yes",IF(J3<"1/1/1999","Yes","No"))
