new to IF's (or vLookup)

new to IF's (or vLookup)

Post by John » Thu, 02 Feb 2006 00:17:11


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 |
 
 
 

new to IF's (or vLookup)

Post by Anne Tro » Thu, 02 Feb 2006 00:24:41

Try this:
http://www.yqcomputer.com/
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 
 
 

new to IF's (or vLookup)

Post by Bob Philli » Thu, 02 Feb 2006 00:36:55

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)



text
how
 
 
 

new to IF's (or vLookup)

Post by John » Thu, 02 Feb 2006 01:41:11

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)
 
 
 

new to IF's (or vLookup)

Post by Bob Philli » Thu, 02 Feb 2006 02:09:04

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)





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


the
 
 
 

new to IF's (or vLookup)

Post by John » Thu, 02 Feb 2006 02:51:20

Ahhh... I can see clearly now!!

Thanks Bob!