Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Store Functions by a name
I need to store a function by a name.
I am reusing these 5 functions and if I could store them in a name it would help greatly. Here is what I am doing: '(And) =IF(Location1="T",IF(Location2="T","T","F"),"F") Would I make this into a macro? How would I approach this? Thanks, Kirk |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Store Functions by a name
Kirk,
You may not need to. If the functions you are trying to (re)create are as simple as this "and" function, Excel has inbuilt functions to handle this. For example, you could rewrite this formula as: =IF(AND(Location1="T",Location2="T"),"T","F") Alternaltively, if you replaced your "T"s and "F"s with TRUEs and FALSEs, you could simply use: =AND(Location1,Location2) HTH, Ryan "captain118" wrote: I need to store a function by a name. I am reusing these 5 functions and if I could store them in a name it would help greatly. Here is what I am doing: '(And) =IF(Location1="T",IF(Location2="T","T","F"),"F") Would I make this into a macro? How would I approach this? Thanks, Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif question | Excel Worksheet Functions | |||
Countif question | Excel Worksheet Functions | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions |