Hello,

I have a situation, wherein, Column-A and Column-B can have one of the
three values: Low, Medium, High. I would like Column C to be filled up
with a value based on the combination of values in column A and B.

For example:

column A Column B Column C
low low 2
low medium 10

Use of =IF(AND(A1='Low',B1='low'),2,1000) works for only one such
combination. I would like all such cases to be "ORed".

Any help would be great...!! Thanks.