| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an excel function
Hi, Im sick and tired always having to use VB when a Case structure is need,
how could I create a case structure; I want to appears like this: €œ=case(a1=b1;ab1;a1=b2;c1;a1=b3;ab3;a1=b4;b1€¦. .)€ or €œ=case(a1=b1;a1=b2;ab1;c1€¦..)€ In English: When a1=b1 print ab1, when a1=b2 print c1 and so on. So, how could I create my own case function? PD. I know €œ=if€ allow 9 condition, I dont want use =if, =vlookup, =lookup or =hlookup TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Function in Excel 2003 | Excel Worksheet Functions | |||
| Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
| Help Creating a Function in Excel | Excel Discussion (Misc queries) | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Creating a new sinus function in VBA Excel | Excel Programming | |||
Threaded Mode
