On Wed, 2006-03-08 at 17:57 -0600, Fred Grant wrote: > 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.
Hi Fred, Dennis said he didn't want to use macros, unless he's not aware that you can call macros from formulae. Or is there another way you can define your own functions? By the way, you left me in as a quoted respondent when there's actually nothing of my text in there. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
