One way
=IF(AND(A1="L",B1="L@"),A1,IF(AND(A1="L",B1="M"),B 1,IF(AND(A1="L",B1="H"),"M
",IF(AND(A1="M",B1="H"),B1,""))))
assuming that if neither of the conditions are true, blank result
Regards,
Peo Sjoblom
"Kamsa" wrote in message
...
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"
|