K
Kaci Tizi Ouzou
Hi all,
Can anybody tell me how can I slide a formula contsinaing a constant
across lines and along columns.
Here is an example
a11 a12 a13
a21 a22 a23
a31 a32 a33
What I would like to have is
a11 a12 a13
a21/a11 a22/a11 a23/a11 : For this I use =CELL/$CELL$XX and slide
across
a31/a11 a32/a11 a33/a11 : Seems like sliding the previous formula
along
columns is not working.
Cheers
Can anybody tell me how can I slide a formula contsinaing a constant
across lines and along columns.
Here is an example
a11 a12 a13
a21 a22 a23
a31 a32 a33
What I would like to have is
a11 a12 a13
a21/a11 a22/a11 a23/a11 : For this I use =CELL/$CELL$XX and slide
across
a31/a11 a32/a11 a33/a11 : Seems like sliding the previous formula
along
columns is not working.
Cheers