On Mon, 2006-03-06 at 19:20, Ross Johnson wrote: > On Mon, 2006-03-06 at 14:30 -0800, Dennis Marks wrote: > > This is a feature that I believe that Excel had in the past and may still > > have. I wish OOo had it, or does it? I would like to create a function > > WITHOUT USING MACROS. Just like we are able to define cell ranges with a > > name I would like to define a function with a name. > > > > For example I have the follow in a cell on my spreadsheet. > > > > =IF(D27=0;EASTERSUNDAY(IF(G27>0;G27;$Calendar.$C$3))+E27;DATE(IF(G27>0;G27;$Calendar.$C$3);D27;K27)) > > > > I would like to do something like: > > > > MYFUNCTION(val1;val2;val3;val4;val5;val6)=IF(val1=0;EASTERSUNDAY(IF(val2>0;val2;val3))+val4;DATE(IF(val2>0;val2;val3);val5;val6)) > > > > Now all I have to do is place =MYFUNCTION(val1;val2;val3;val4;val5;val6) in > > a cell instead of the formula. > > > > My actual formula would probably have twice the length than my example but > > I > > would not have to constantly repeat it. > You could write your own user defined function and call it with the required parameters. -- Fred
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
