On Sunday 13 May 2007, + John ALLUM wrote: > [ MODERATED ] ******************** > I am trying ver 2.2 Calc Tutorial - Look-up functions. I don't know what I > am doing wrong, but I do not get the results shown at the bottom of page 2 > and top of page 3. Where the tutorial states that cells B1, B2 & B3 should > ALL have A1 as part of the copied formula, my s/sht shows A2 in B2 and A3 > in B3, and so on. This does not seem to agree with the 3rd line of page 3 > of the tutorial, viz. "Note that cell A1 does not change..." Have I > missed something somewhere. I expected cell A1 to remain the same but the > cell refs in B2 etc to ALL increase by 1. C U
As you are not subscribed you may not have seen that: On Sunday 13 May 2007, JosephK wrote: > > When copying formulae, if you do not want the cell reference to change > then prefix the cell ref with $. > e.g. if in cell b1 you have a formula =a1+a2 then copying b1 to b2 will > result in b2 holding the formual =a2+a3. i.e. it increments the > references relative to the original. If what you need is the exact same > formula to be copied then make the formula in b1 =$a$1+$a$2. When you > copy it to b2 it will stay the same. > > Look up absolute and relative references in the help Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
