K
Kkakes33
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!!!
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!!!