Developer Forum

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 |

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

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

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)

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

Ahhh... I can see clearly now!!

Thanks Bob!