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 =