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?