How do I use IF in Excel to string the two text values (high,low)

G

Guest

I am trying to build an IF statement that will string the 2 column text
values of "high" and "low" to return a specific text value in the 3rd column.


I have 4 categories of reference to consider when writing this formula:
=IF("high","high", then "gold"); IF("high", "low", then "silver"); IF("low",
"high", then "bronze"); IF("low", "low", then "lead").
 
R

Ron Rosenfeld

I am trying to build an IF statement that will string the 2 column text
values of "high" and "low" to return a specific text value in the 3rd column.


I have 4 categories of reference to consider when writing this formula:
=IF("high","high", then "gold"); IF("high", "low", then "silver"); IF("low",
"high", then "bronze"); IF("low", "low", then "lead").
Click to expand...


=IF(AND(A1="high",A2="high"),"gold",
IF(AND(A1="high",A2="low"),"silver",
IF(AND(A1="low",A2="high"),"bronze",
IF(AND(A1="low",A2="low"),"lead"))))

It will return FALSE if none of the conditions match.


--ron
 
G

Guest

Hi,

You may try this.

if
(and(cell="high",cell1="high"),"gold",if(and(cell="high",cell1="low"),"silver",if(and(cell="low",cell1="high"),"bronze",if(and(cell="low",cell1="low"),"lead",0))))

Regards,

Ashish Mathur
 
G

Guest

Ron,

Your assistance has been invaluable.....thanks so much for that.

Kind regards,
f
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Result from data in two columns....Best function to use? 5
How do I asssign a values to two cells and multiply them together 3
Can Excel do this? and if so which formula should I use 4
How can I give text (A,B...) a number value in Excel (A=1, B=2..) 3
in a single worksheet,hw to match values based on 2 list 2
How to express this in an if statement. 3
In col if high is 83 and low 15 how do i get high =100 and low=0 2
How do create a formula to evalute a # to return 1 of 4 conditions 4

Top