new to IF's (or vLookup)

J

JohnB

What would be the best way to accomplish this;

I want to test the value of the first cell, it can be 1 of 3 different text
strings, with the second field filled with an integer value, based on the
test results. I'm guessing I need multiple IFs? What I'm stuck on is, how
do you string them together?
Thanks



| text string1 | integer |
| text string2 | integer |
| text string3 | integer |
 
B

Bob Phillips

Do you mean

=IF(AND(OR(cell1="text1",cell1="text2",cell1="text3"),cell2=integer1),action
_true,action_false)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
J

JohnB

I want to test c14 for one of the 3 string values. And then fill E13 with
one of the 3 integers, based on the test.

Am I even close?

=IF(AND(OR(C13="Spruce Creek",C13="Stone Creek",C1="Fore
Ranch"),E13=34,E13=10,E13=6),action_true,action_false)
 
B

Bob Phillips

Then add this to E13

=IF(C13="Spruce Creek",34,IF(C13="Stone Creek",10,IF(C1="Fore Ranch",6,"")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
J

JohnB

Ahhh... I can see clearly now!!

Thanks Bob!


Bob Phillips said:
Then add this to E13

=IF(C13="Spruce Creek",34,IF(C13="Stone Creek",10,IF(C1="Fore
Ranch",6,"")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...
 
Top