IF statement for vested years greater than 10

[link062]

I was wondering if any one could help me out. I am trying to write an IF statement for vested years that are greater than 10. I have tried multiple styles but did not have any luck. I need to apply the statement to the entire column as well. this is what I had but all I keep getting is yes in every cell when it should be blank =IF(F11>10,"YES",IF(F11<10,""))

[jeffreybrown]

Please explain what is not happening that you expect as the formula appears ok.

Give some examples?

[link062]

I am trying to get the statement to return a yes for anyone with 10 or more years. When I apply the formula to the column everything becomes a yes when in actualality some should still be blank.

[link062]

In the f column I have years of service the first five are (15,15,2,2,6). Now I have the I column for the vested years where I am trying to apply the formula. All I need is a yes for anyone with 10 or more years.

[jeffreybrown]

With your first five figures, your formula returns Yes, Yes, "", "", ""

What do you expect?

[link062]

On my excel spread sheet I am not getting those answers though i am getting yes in all of them

[jeffreybrown]

How about attach the sheet so we can see it?

or try

=LOOKUP(F2,{0,10},{"","Yes"})

[link062]

I need an if statement the look up did not work

[jeffreybrown]

In J13 and copied down...

=IF(G13<>"",IF(LEFT(G13,FIND(" ",G13)-1)+0>$H$11,"YES","N0"),"")

[link062]

It now gives me only no answers

[jeffreybrown]

How's this

[link062]

same thing it is locked on the no answer

[jeffreybrown]

On second thought, I would even go one step further by applying a custom format to the years column so it takes only numbers, but you can also see the title of years.

Now in the formula we can remove the Left function and just evaluate the numbers of years against the vested years variable.

[link062]

now its locked on yes, Idk if this helps but my formula to calculate the years of service in the original document column is =DATEDIF(B12:B754,Start_Date,"y")&" years". From there I need the IF statement to just say vested yes or " '', but im not getting it, it keeps getting locked on one answer

[link062]

the question was still not answered anyone with help please help. on my other formulas I had to define names on the equations and all.

[jeffreybrown]

now its locked on yes, Idk if this helps but my formula to calculate the years of service in the original document column is =DATEDIF(B12:B754,Start_Date,"y")&" years".

I would like to help further, but you need to help also. When you post a sample, post what you actually have so we can tailor an answer to meet your needs.

[link062]

need help writing formula for vested years using an if statement. I have used multiple formulas but the answer gets locked on whatever it is labled as to the entire column. I have used =if(f11>=10,"yes'','' '') as well as other variations. I have posted a test document with this post. I can get the formula to work if the information is copied to a new document but I need it to work in the original.

[jeffreybrown]

In I11 try...

=IF(F11<>"",IF(TRIM(LEFT(F11,2))+0>$G$9,"YES","N0"),"")

[link062]

Yes finally thank you so much. do you know why the other ways it was written would not work, why did it have to be written like this?

[jeffreybrown]

Well with the other ways you were writing it the formula could not handle the number of years and the text "years" in the same cell.

That is why the left function was used to extract just the numbers so you could compare it to the vested number of years.

Another method:

In F11 >> =DATEDIF(B11,Start_Date,"y")+0

In I11 >> =IF(F11<>"",IF(F11>$G$9,"YES","N0"),"")

Custom Format Column F

• Right click cell (or Ctrl + 1)
• Format Cells
• Number
• Custom
• Type: 0" years""

Now column F appears as 15 years, but in reality, the cell contents contents only 15.