I need a formula for some calculations...

[Guest]

Ok, this is really difficult to explain, so I'm just going to go for it. I
have a product database that I edit using Excel 2003. I have thousands of
products and the buy and sell prices change several times a day. Doing this
using % formulas is WAY too time intensive.

The way the spreadsheet is set up is like this: A2 is product name, B2 is
buy price, C2 is sell price. Basically, I want a formula that will take a
specific percentage of the sell price and make it the buy price. But, since
every product is different and I have several thousand in the spreadsheet, I
simply cannot do a cell by cell formula. Is there a blanket formula that
would apply to a whole column, but would be calculated on a row by row basis
using each individual cell value? Does this question even make sense?

I am at my wit's end, so any help would be greatly appreciated!!!

 

[Guest]

You are doing the reverse of the usual process. Normally the buy price is
fixed. If we would like a 7% profit on each item we would use:

=B2*1.07 in cell C2 and just copy down the column

to get the reverse use:

=C2/1.07 in cell B2 and copy down column B