New user....help appreciated

[drwho]

I need to apply the formula x=[Mz+(0.057*Fx)]/Fy to calculate x; given Fx, Fy and Mz.

I have entered Fx in a column A2:A10, Fy in a column B2:B10 and Mz in acolumn C2:C10.

Can anyone tell me how to apply this formula to the column D2 through D10 without having to enter the formula in each separate D cell altering the reference cells?

Any help would be grately appreciated......deadline looming!

[swatsp0p]

enter this formula in D2 and copy down to D10:

=C2+(0.057*A2)/B2

note: to copy down, click in cell D2, hover your cursor over the lower right corner (a small black square) of the cell until the cursor becomes a '+', then click and drag this down to D10 and release. This will copy the formula down and adjust the reference in each to reflect the current row's data.

Good Luck