IF function

[Sharon]

Hi, here is what I need
Headers Column F Probability Column G = Impact Column H = Rate

if F14 = H I want the H to remain visible but the number for calulations to
read 3
If F14 = M ............................................... the number for
calulations to read 2
if F14 = L ................................................ the number for
caluations to read 1

I have two columns that I want the text (H,M,or I) to show, but I need the
corresponding numbers to somehow be behind the scene so that the third column
H can calcualte the rating F14*G14 =

 

[joeu2004]

I have two columns that I want the text (H,M,or I) to show,
but I need the corresponding numbers to somehow be behind
the scene so that the third column H can calcualte the rating F14*G14

The most straight-forward expression would be:

G14*if(F14="H", 3, if(F14="M", 2, 1))

Alternatively:

G14*(1 + 2*(F14="H") + (F14="M"))

I am assume that 1 is the correct factor even if F14 is not "L", "H"
or "M".


------ original posting -----

 

[Sharon]

Hi, the executives will enter and H, M, or L in both of the first to columns.
H is for high, M - Medium and L = Low Probability or Impact. If the
executive place an H under the Probability column I want it to calculate as
the #3 likewise if they enter M I want the calculation to be 2 and if they
enter an L I would like for the calculation to be a 1. Same for both the
Probability and Impact columns.

Sample of chart.

Probability Impact Rate (F*G)
H H 9
M H 6
L M 2

If the numbers were to be visible, they would read as below. The problem is
the executive doesn't want the numbers to show but rather the Letters.
3 3
2 3
1 2

 

[Lars-Åke Aspelin]

Try the following formula in cell C2 and copy it down as far as
needed:

=MATCH(A2,{"L","M","H"},0)*MATCH(B2,{"L","M","H"},0)

Hope this helps / Lars-Åke