Re: Relative/absolute cell references

Maybe

=INDIRECT("A1")*INDIRECT("A3")

--
HTH

Bob Phillips

"Jan Kronsell" <span@xxxxxxxxx> wrote in message
news:%23qsTwdIVFHA.3540@xxxxxxxxxxxxxxxxxxxxxxx
> I have a formula, like for instance = A1*A3
>
> I like to copy this, relatively, that is updating it to =A2*A4 and so on.
>
> The data is supposed to be in A1, A3 or A2, A4, but if the user moves the
> data from A1 to B1 the fomula is updated to =B1*A3.
>
> Is there someway I can prevent that? So no matter where the user moves the
> data, the formula will remain unchanged?
>
> Jan
>
>


.

Relevant Pages

  • Re: Conditional formating, values.
    ... The trick is to ensure that that is the first condition, ... > HTH ... > Bob Phillips ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Totaling Months
    ... HTH ... Bob Phillips ... > I have 3 columns in my worksheet, column F Date Due, column G is Date ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: excel sorting task
    ... HTH ... Bob Phillips ... > I have the following data in a worksheet ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: How do I make a column of checkboxes quickly?
    ... HTH ... Bob Phillips ... > I have a list of people my company has already mailed letters to (about ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: nested formula with if condotion
    ... HTH ... Bob Phillips ... > can anybody helpme out to put formula using if or any other ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)