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.
- keerokLv 73 months ago
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.
- opurtLv 73 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.