compare words

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

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

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

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

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

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

Check out your other post.

--
Jacob


"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

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

I copied your formula into C1 and it is fine. Initially it shows a result of
medium but that was because i key in high into A1 and medium into B1 instead
of High and Medium.

Can you go to the tab 'formula / evaluate formula' and click the button
evaluate and go through the evaluation process? It might throw up what
happens.

"Postman" wrote:

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

Can you help me to check this? the " sign that you see should not be this
sign ' enter twice. It should be enter once on this "

"ck" wrote:

I copied your formula into C1 and it is fine. Initially it shows a result of
medium but that was because i key in high into A1 and medium into B1 instead
of High and Medium.

Can you go to the tab 'formula / evaluate formula' and click the button
evaluate and go through the evaluation process? It might throw up what
happens.

"Postman" wrote:

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