Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!ames!ncar!asuvax!mcdphx!mcdchg!att!chinet!les
From: les@chinet.chi.il.us (Leslie Mikesell)
Newsgroups: comp.sys.ibm.pc
Subject: Re: Multiplan Question
Message-ID: <9817@chinet.chi.il.us>
Date: 19 Oct 89 14:25:00 GMT
References: <128@mscf.med.upenn.edu>
Reply-To: les@chinet.chi.il.us (Leslie Mikesell)
Organization: Chinet - Chicago Public Access UNIX
Lines: 22

In article <128@mscf.med.upenn.edu> butterworth@mscf.med.upenn.edu writes:
>I'm new to this group and aren't sure whether it's primarily hardware or
>software related, but I do have a software question. 
>
>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? 

Multiplan (and most other spreadsheets) has both absolute and relative
references.  The RnCn type reference that you show is absolute and does
not adjust when moved.  In Multiplan, a relative reference will look
something like R[+n]C  (where n is a number).  The easiest way to get
them is to use the arrow keys to postion to the cell you want to reference
when you enter the formula.  There are times that you want want both
types of reference, but for "sum of column" type things, relative is
the type you need.

Les Mikesell
  les@chinet.chi.il.us