Howdo U copy a formula down a column, that uses data in another w.
 

Im trying to copy a formula to the rest of a column. The Formula uses the
same data that sits on a different worksheet. Currently, when I copy and
past the formula, the cells the formula references change. Ex. my data has
different weights. I know that 1 lb will charge $10 to ship. 2lbs=$12 to
ship, etc. I need my formula to look at the weight and see the IF statement
to determine its cost of shipping. I have the formula correct, but I need
help in pasting this formula to the rest of the worksheet while referring to
the same data.

thanks a bunch

"Maglor" wrote:


Use $-signs to block the cells that may not change while copying the
formula...

f.e.

is A1 contains the charged price, turn it into $A$1 to 'lock' it. When
you'd copy the formula without $-signs A1 would turn into A2, A3,
A4,...

$A$1 would always stay A1 in that case, due to the $-signs...


On Fri, 25 Feb 2005 02:09:07 -0800, Need Help pasting a formula <Need
Help pasting a wrote:

Im trying to copy a formula to the rest of a column. The Formula uses the
same data that sits on a different worksheet. Currently, when I copy and
past the formula, the cells the formula references change. Ex. my data has
different weights. I know that 1 lb will charge $10 to ship. 2lbs=$12 to
ship, etc. I need my formula to look at the weight and see the IF statement
to determine its cost of shipping. I have the formula correct, but I need
help in pasting this formula to the rest of the worksheet while referring to
the same data.