excel if formula help for above 2 years, 1 to 2 years, 6-12 months, less than 6 months. shown Yes in 1 to 2 yrs, >6m, >3m columns.?

Question

excel if formula help for categorising the no. of days as 

a) above 2 years,

b) 1 to 2 years,

c) 6-12 months,

d) less than 6 months.

The the largest creiteria only reported "Yes". The smaller criteria to be omitted, when the criteria is larger.

eg,. >2 years only shown yes in respected column of  >2 yrs. 

But not to be shown Yes in 1 to 2 yrs, >6m, >3m columns.

Answer 1

Nested IFs.

B = Age in yrs.

F = 1-2 yrs.

G = > 2 yrs.

If B2 > 2, in F2 type;

=IF(G2="YES","",(IF(AND(B2>1,B2<2.1),"YES","")))

For this to work, G2 must be "YES". I suppose you figured that out already.

Answer 2

So what formulas have you tried, so that we can give advice? 

Or are you just trying to get us to do your homework for you.