Hello,
I would like a function that would output the years on hand by group max column based on the estimated years on hand max column. I have been able to complete the function by doing If, And statement, however it is a long formula. Is there a shorter way to complete with a range?
<tbody>
</tbody>
thank you for your help
I would like a function that would output the years on hand by group max column based on the estimated years on hand max column. I have been able to complete the function by doing If, And statement, however it is a long formula. Is there a shorter way to complete with a range?
Estimated Years on Hand Max | Year On Hand by Group Max |
3.03 | 3-4 years |
8.65 | 5+ years |
1.21 | 1-2 years |
5.34 | 5+ years |
1.58 | 1-2 years |
7.78 | 5+ years |
0.42 | Less then 1 year |
<tbody>
</tbody>
thank you for your help