Formula quandary?
 

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 didnt work
How do I go about doing that please?

Formula quandary?
 

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
---------------
Jacob Skaria


"shallowz" wrote:

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 didnt work
How do I go about doing that please?

Formula quandary?
 

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

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"shallowz" wrote:

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 didnt work
How do I go about doing that please?

Formula quandary?
 

Go back to your original posting and read replies.

Best to always stay with the thread you started first.



Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 07:46:06 -0700, shallowz
wrote:

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?