Find and Replace problem
 

I am trying to edit a product file. The file contains a column that has
product weights. I need to replace these weights with a shipping price for
my products. The weights vary from 1 lb - 100 lbs. I have tried to use
replace, but as I do this, I start to replace some of the cells that have
already been edited for price. Does some one have a formula or advice that I
may use for this?
--
Brad

Find and Replace problem
 

Give some info. What are the rnages? 0 to 5 lbs = $4.00, 6 to 12 = $6.00,
for example. There are few ranges we can use IF otherwise a llokup
(VLOOKUP...) would be useful
best wishes
--
www.stfx.ca/people/bliengme


"brad547190" wrote:

I am trying to edit a product file. The file contains a column that has
product weights. I need to replace these weights with a shipping price for
my products. The weights vary from 1 lb - 100 lbs. I have tried to use
replace, but as I do this, I start to replace some of the cells that have
already been edited for price. Does some one have a formula or advice that I
may use for this?
--
Brad