| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing nested if statements into a user defined function
Hi
depends on your conditions. But in most case no UDF required but simply applying a different alorithm or using a lookup table should work. So you may post your complete conditions :-) -- Regards Frank Kabel Frankfurt, Germany "Rob Slagle" schrieb im Newsbeitrag ... I have several financial worksheets where I am figuring a percent change with a nested if(and statements. c1 =if(and(a1=0,b1<0),-1,if(and(a1=0,b10),1,....etc. how do I make this into a user defined function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user defined function | Excel Worksheet Functions | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| User-defined data type; Error: Only User-defined types... | Excel Programming | |||
| Nested IF Statements - Worksheet Function | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Threaded Mode
