Technology Tips and News
I have the following
| Health | Priority | Life-cycle |
| 1 | 1 | 1 |
| 1 | 1 | 2 |
| 1 | 3 | 1 |
|
this list is 45+ long I want to use "if statements |
|
to generate a 4th number, but the if statement will be huge. Any better way of making this:
| Health | Priority | Lifecycle | Impact |
| 1 | 1 | 1 | 1 |
| 1 | 1 | 2 | 2 |
| 1 | 3 | 1 | 3 |
| 1 | 1 | 3 | 3 |
| 3 | 1 | 1 | 3 |
| 1 | 1 | 4 | 4 |
| 1 | 5 | 1 | 5 |
| 1 | 1 | 5 | 5 |
| 5 | 1 | 1 | 5 |
Is the impact simply the highest of the values of health, priority and lifecycle? If so, the formula in D2 would be
=MAX(A2:C2)
and this can be filled down. If there is another "rule" for determining the impact, please explain.
This topic is archived. No further replies will be accepted.
Other recent topics
Click here to get your free copy of Network Administrator. Over 25 plugins to make your life easier