This the formula I have:
=IF(C8=5,100%)*IF(F8=5,5000000)

The 5 in each part is a reference to a probability and an impact and both
variables go from 1-5 with different values and percentages applied to both.
I need this formula to calculate that if for example there was a probability
of 1 and an impact of 5 what the assigned value would be and do this for
every single combination of values and impacts (25 in total)

HELP!