123 asked in Computers & InternetSoftware · 1 month ago

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.?

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.

Attachment image

2 Answers

Relevance
  • keerok
    Lv 7
    1 month ago

    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.

  • opurt
    Lv 7
    1 month ago

    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.

Still have questions? Get your answers by asking now.