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!
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
Last edited by swatsp0p; 01-07-2005 at 10:07 AM. Reason: additional information...
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks