| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help please
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
=IF(A1="New York",25,"")
Regards, Stefi shallowz ezt *rta: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
=IF(A1="New York",27,"")
If this post helps click Yes --------------- Jacob Skaria "shallowz" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
Try something like this...
=IF(A1="Test","true result", "false result") "shallowz" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
=IF(A1="New York",25,"")
it ends with a pair of double-quotes with nothing between them best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "shallowz" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
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 "Stefi" wrote: =IF(A1="New York",25,"") Regards, Stefi shallowz ezt *rta: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
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. "shallowz" wrote: 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 "Stefi" wrote: =IF(A1="New York",25,"") Regards, Stefi shallowz ezt *rta: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
=LOOKUP(A1,{"Alaska","Maine","New York",""},{13,48,25,""})
If more cases, use a VLOOKUP table. Gord Dibben MS Excel MVP On Tue, 7 Jul 2009 06:55:01 -0700, shallowz wrote: 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 "Stefi" wrote: =IF(A1="New York",25,"") Regards, Stefi shallowz ezt rta: 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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
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 "Stefi" wrote: =IF(A1="New York",25,"") Regards, Stefi shallowz ezt *rta: 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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help please
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! raju wrote: 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 "Stefi" wrote: =IF(A1="New York",25,"") Regards, Stefi shallowz ezt *rta: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
