I have a spreadsheet designed to calculate material costs for certain products. the materials remain constant but the prices change frequently...what I need is to be able to change prices (several at once) without changing the material quantity. So, say I have a price of $3.11 for a certain product but I also have a material quantity of 3.11, how do I change the $3.11 without changing the 3.11?

Keep in mind that there will be multiple cells with the same number that needs changed.

Thanks
Tom