In A1 i wrote - High
In B1 i wrote - Medium
In C1 i wrote - =if(SUMPRODUCT(--(A1="High"),--(B1="Medium")),"High","Medium")

and it gives me error in this section "(--(A1="High")," (in the comma sign).



"ck" wrote:

Can you post your formula here? I tried on 2007 and it does not produce error.

"Postman" wrote:

it gives me a error. :( it's not like that. Btw i'm using excel 2007.

"ck" wrote:

In C1, paste this

=IF(SUMPRODUCT(--(A1="High"),--(B1="Medium")),"High","Medium")

What it does is that if A1=high and B1=medium, C1 will be high. Any other
combination will result in C1 being medium. So if you have more than these 2
combination, you need to set more criteria to make it more robust.

Click yes below if it works

"Postman" wrote:

hi there. Let's talk about my second scenario. Can you help me with the
formula. How exactly needs to look my formula in this case?

Thanks

"ck" wrote:

in your first example, to see "high" in column C1, you need to put =A1 in
cell C1. However, this will also shows "high" in your 2nd scenario. So you
need to determine why in the first example, you need a "high" and in the
second scenario, it should be "medium" and set the required formula. Maybe a
IF statement will be useful.

"Postman" wrote:

Hi All,

I have a question about one formula. I have text "High" in column A1 and
text "Medium" in column B1. In column C1 i would like to see "high". How to
do it?
And what about if i have in A1 "high" and in B1 - "low" and i would like to
have "medium" as a result in C1?

Thank you in advance