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%...