=IF(A2="L",IF(B2="L","L",IF(OR(B2="M",B2="H"),"M","")),IF(AND(A2="M",B2="H")
,"H",""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kamsa" <Kamsa@discussions.microsoft.com> wrote in message
news:39B29E7A-1875-4E6D-BDA3-A9C4D94BBCE8@microsoft.com...
> Help, I think I have done this before but cannot remember or how I did it.
>
> For a risk log, I want a formular that will pick up from 2 cells a number
of
> combinations and give me the result in the third cell
>
> ie. Risk If cell a is "L" and cell b "L@ then cell c should be "L"
> however if a is "L" and cell b is "M" then cell c should "M"
> and if a is "L and b is "H" then c should be "M"
> and if a is "M" and b is "H" then c should "H"
>
>