i have variables A,B,C,D,E, which C and D's calculations depends on the
values of A and B. E = C/D.

Now i have a column of different A values and I need to evaluate for each A,
what is the corresponding E value.
sample table:

Values A E
A = 10 15 corresponding value to A = 15
B = 20 20 corresponding value to A = 20
C = function of A & B. 25 "
D = function of A & B. 30 "
E= C/D 35 "
40 "

is there a way I can edit the formula for E values in the 3rd column to drag
down for each corresponding value of A?

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