How can I paste a formula that references a chart of data

G

Guest

I have a page of data that includes the weight of each item. I set up IF
statements to read a chart of data to determine the shipping costs based on
its weight. Ex. if the weight is < 2lbs, then $5.00, etc) The formula
works on one cell but when I try to copy it to the cells below, the formula
changes as does the cell #'s. Cannot figure this out.
 
J

Jonathan Rynd

The formula
works on one cell but when I try to copy it to the cells below, the
formula changes as does the cell #'s. Cannot figure this out.
Click to expand...

Look up "absolute" and "relative" cell references in Excel help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate shipping costs in excel 2007 2
Howdo U copy a formula down a column, that uses data in another w. 2
The right formula is? 2
excel 2003 - revising a formula to make it more accurate 3
Proper function for a chart 1
SUM formula (sort of) 1
VLOOKUP-How do I get answers pulled from different appropriate col 2
Formula for growth chart? 5

Top