Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!uakari.primate.wisc.edu!ginosko!uunet!zephyr.ens.tek.com!tektronix!psueea!parsely!bucket!leonard
From: leonard@bucket.UUCP (Leonard Erickson)
Newsgroups: comp.sys.ibm.pc
Subject: Re: Multiplan Question
Message-ID: <1720@bucket.UUCP>
Date: 20 Oct 89 20:02:26 GMT
References: <128@mscf.med.upenn.edu>
Organization: Rick's Home-Grown UNIX; Portland, OR.
Lines: 38

butterworth@mscf.med.upenn.edu writes:

>I'm using Multiplan V2.01 (don't laugh; someone gave it to me and I can't
>afford Lotus right now) and need to copy formulas from one column to another.
>If I have a formula of, say, SUM(R6C10:R6C15) and I copy it to the cell below,
>it simply duplicates the formula.  What I want it to do (am I dreaming,
>possibly) is modify the entry so that it takes the new row into consideration,
>i.e. SUM(R7C10:R7C15).  Is this possible? 

Your current formula is using *absolute* addressing. You need to change it
to use *relative* addressing. When you first enter formula do it like this:
	press the = key to get into value/formula entry mode
	type "sum("
	now use the arrow keys to move to the first cell of the range
	type ":" (you'll be returned to the cell the formula is in)
	arrow over to the *last* cell of the range
		(note that the range is highlighted for you!)
	type ")" to finish the formula

If you want to edit the existing formula just change it to indicate the
*displacement*. For your example, here's what the relative formula would
look like in various cells:
	row 	formula			better formula
	r5	sum(r[-1]c10:r[-1]c15)	sum(r[-1] c10:15)
	r6	sum(rc10:rc15)		sum(r c10:15)
	r7	sum(r[+1]c10:r[+1]c15)	sum(r[+1] c10:15)

the "better formula" uses the Multiplan feature of specifying a range as
the intersect of a pair or ranges. I have spreadsheets with formulas like
sum(year r) (ie the sum of the values in the current row that are also in
the named range "year")


-- 
Leonard Erickson		...!tektronix!reed!percival!bucket!leonard
CIS: [70465,203]
"I'm all in favor of keeping dangerous weapons out of the hands of fools.
Let's start with typewriters." -- Solomon Short