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.
About 25 years ago I wrote a spreadsheet application for a homebuilt 8 bit computer (in BASIC). Because it only had 8k bytes of RAM and no disk (program loaded from cassette tape), I allowed it to do exactly this. Mainly to conserve memory. But it also allows a spreadsheet to be self- modifying. Which can either make the spreadsheet absolutely amazingly powerful, or absolutely amazingly unpredictable and an absolute nightmare to debug. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
