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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an excel function
Hi there,
Well, you are limited to 7 nested IF functions - not 9; 8 with the original. And why not a LOOKUP? Is there something wrong with those? Why a UDF? What does your data look like and what are the ranges in which you are looking at? Please explain more. -- Regards, Zack Barresse, aka firefytr "filo666" wrote in message ... Hi, I'm 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 don't want use =if, =vlookup, =lookup or =hlookup TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an excel function
Why not use one of the lookups? Lots more equalities can be included, much
easier to maintain, etc, etc, etc For your first example. assuming the conditions are mutually exclusive. =(a1=b1)*ab1+(a1=b2)*c1+(a1=b3)*ab3+.... If they're not mutually exclusive then...good luck "filo666" wrote in message ... Hi, I'm 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 don't want use =if, =vlookup, =lookup or =hlookup TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating an excel function
Use the choose worksheet function.
-- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I'm 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 don't want use =if, =vlookup, =lookup or =hlookup TIA |
Reply |
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 |