123 asked in Computers & InternetSoftware · 3 months 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

  • keerok
    Lv 7
    3 months ago

    Nested IFs.

    B = Age in yrs.

    F = 1-2 yrs.

    G = > 2 yrs.

    If B2 > 2, in F2 type;


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

  • opurt
    Lv 7
    3 months 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 answers by asking now.