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!

The formula you currently have returns 5000000 if C8 and F8 are both 5, and
zero otherwise. Presumably you want different factors to be applied if there
are other values in C8 and/or F8, but you have not shared how those factors
would change. If the factors can be caculated from a simple formula, then
using that formula would probably be best. Otherwise consider having a
lookup table for the factors and use the VLOOKUP function to retrieve the
appropriate factors.

Jerry

"Pasty" wrote:

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!

The problem I have is with the look up table is that I have two dimensions
and vlookup and hlookup only seem to be able to look up or across but not
both.

"Jerry W. Lewis" wrote:

The formula you currently have returns 5000000 if C8 and F8 are both 5, and
zero otherwise. Presumably you want different factors to be applied if there
are other values in C8 and/or F8, but you have not shared how those factors
would change. If the factors can be caculated from a simple formula, then
using that formula would probably be best. Otherwise consider having a
lookup table for the factors and use the VLOOKUP function to retrieve the
appropriate factors.

Jerry

"Pasty" wrote:

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!

If your formula is not separable into pieces that depend on only one
dimension, then create a formula that uniquely combines the two values into a
single value to use as an index your lookup table. Two of the possibilities
with values from 1 to 5 are
=(C8-1)*5+F8
=C8&F8

Jerry

"Pasty" wrote:

The problem I have is with the look up table is that I have two dimensions
and vlookup and hlookup only seem to be able to look up or across but not
both.

"Jerry W. Lewis" wrote:

The formula you currently have returns 5000000 if C8 and F8 are both 5, and
zero otherwise. Presumably you want different factors to be applied if there
are other values in C8 and/or F8, but you have not shared how those factors
would change. If the factors can be caculated from a simple formula, then
using that formula would probably be best. Otherwise consider having a
lookup table for the factors and use the VLOOKUP function to retrieve the
appropriate factors.

Jerry

"Pasty" wrote:

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!