View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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"