I've done quite a bit of reserach on this but can't quite master the formula required for the following:
<tbody>
</tbody>
* Assume Location is A1.
What is the formula if I want to Location 2, Result Moderate and Flood?
Thanks
Location | Result | Arson | Crime | Flood | Subsidence |
1 | Not Covered | 1.00 | 1.00 | 1.00 | 1.00 |
2 | Negligible | 0.85 | 0.85 | 0.85 | 0.85 |
3 | Low | 0.95 | 0.95 | 0.95 | 0.95 |
4 | Moderate | 1.00 | 1.00 | 1.00 | 1.00 |
5 | High | 1.10 | 1.10 | 1.10 | 1.10 |
Extreme | 1.15 | 1.15 | 1.15 | 1.15 |
<tbody>
</tbody>
* Assume Location is A1.
What is the formula if I want to Location 2, Result Moderate and Flood?
Thanks