View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
shallowz shallowz is offline
external usenet poster
 
Posts: 10
Default 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?