Formula quandary?

[shallowz]

Still a noob when it comes to excel formulas

I was gratefully given a formula
=IF(A1="New York",25,"")

When I wanted to make cell A7 come up the number 25 if cell A1 is New York

Now I want to know if can place multiples in that same cell for two other
locations for example:

Maine will equal the number 48 and
Alaska will equal the number 13

I tried a couple of things but didn’t work
How do I go about doing that please?

 

[Jacob Skaria]

Try

=IF(A1="New York",25,IF(A1="Maine",48,IF(A1="Alaska",13,"")))

In case you have more check out the help on VLOOKUP()

If this post helps click Yes

 

[shallowz]

WOOHOO
Thank you so much Jacob.
(HIGH FIVE!)

Try

=IF(A1="New York",25,IF(A1="Maine",48,IF(A1="Alaska",13,"")))

In case you have more check out the help on VLOOKUP()

If this post helps click Yes

 

[Gord Dibben]

Go back to your original posting and read replies.

Best to always stay with the thread you started first.



Gord Dibben MS Excel MVP