On 09:02 Sun 13 May , John ALLUM wrote: > 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 > JOhnA 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 Regards, John -- It is often safer to be in chains than to be free. Joseph K --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
