Formula help please

  • Thread starter Thread starter shallowz
  • Start date Start date
S

shallowz

i am a noob when it comes to excel formula's

this is what i want i hope it can be done

if in cell A1 i have the word New York i would like to have cell A7 show a
number like a 25

Cell A1
New York

As soon is that is typed in

Cell A7
25
Pops up

what is the formula i put in A7 so that can happen please
 
=IF(A1="New York",25,"")
it ends with a pair of double-quotes with nothing between them
best wishes
 
Thank you very much that did work
how do i make it so if i have two or more to add like
Maine will equal the number 48 and
Alaska will equal the number 13

thanks so far for your help
 
Your best bet here is to make a 'lookup table' containing the values you want
referenced and displayed. Then use the LOOKUP function (See the 'Array form'
of the lookup function) to find the value that you want.
 
=LOOKUP(A1,{"Alaska","Maine","New York",""},{13,48,25,""})

If more cases, use a VLOOKUP table.


Gord Dibben MS Excel MVP
 
dear sir

i am working in office excel 2003. when i load any macro it says "Macros in
this workbook are disabled because the security level is high,and the macros
have not been digitally signed or verified as safe. To run the macros. you
can either have them signed or change your security level. click help for
more information."

who i enable the workbook.

thanks.
raju
mumbai
 
Start excel (don't open that workbook).
Tools|Macro|Security|Security level tab|

Change it to Medium and you'll be prompted to allow macros each time you open a
workbook with macros.

Change it to low (microsoft doesn't recomment this!) and you'll never be
prompted, but you may be running macros that are not nice!
 
Back
Top