constant cell ref

  1. M

    Constant Cell reference

    Please advise: I would like a cell reference to be constant. The calculation is like this: a2+b2= c2. c2*a9%=d2. Now, when I go to the next row, I want the a9% reference to be constant while c2 should carry on c3, c4, c5 and on. i.e. the formula should go on like this- c2*a9%, c3*a9%, c4*a9%...

Some videos you may like

This Week's Hot Topics