If you have formulae in C1 and D1, calculating some relationship
between A1 and B1, and in E1 you have the formula =C1/D1, then all you
have to do is to highlight the cells C1 to E1, click <copy (or
CTRL-C), then position your cursor in C2, hold the <shift key down and
click into C6, release <shift then press <enter. The formulae will
now be copied into the cells C2 to E6 and the cell references should
have adjusted automatically. Is this what you meant?

Hope this helps.

Pete