Am trying to automatically sum up Dates based on a certain size of a feature and it's estimate and I am wondering if we can do this without if statements?
So If I enter a new feature of a certain size among Low, Medium, High etc and enter one of these as an upcoming feature and give a start date, I want the rest of the dates to be populated automatically.
List of values:
Low Medium High (Feature Sizes)
A. 5. 10. 20
B 12 12 12
C 0 5 15
Desired table: ( I just give details in column A, B, C and it fetches values in columns D & E based on the value in Column C)
Feature Name | Feature Start | Feature Size | A | B |
---|---|---|---|---|
X | 11/01/2024 | High | =(11/01/2024) + 5 = 11/06/2024 | = 11/06/2024+12 = 11/18/2024 |
Y | 12/01/2024 | Low | 12/06/2024 | =12/18/2024 |
I know I can do it with multiple ifs but I am wondering if there is a cleaner way of doing what I am currently doing.
Better to use ranges, but logic is like:
=B6+INDEX({5,10,20;12,12,12;0,5,15},{1,2,3},XMATCH(C6,{"Low","Medium","High"}))