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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I paste a formula that references a chart of data (https://www.excelbanter.com/excel-worksheet-functions/15047-how-can-i-paste-formula-references-chart-data.html)

brantty

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

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.

Jonathan Rynd

"?B?YnJhbnR0eQ==?=" wrote in
:

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.

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

All times are GMT +1. The time now is 07:40 PM.