I need a formula for some calculations...
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!!! :) |
I need a formula for some calculations...
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 -- Gary''s Student - gsnu200748 "Kkakes33" wrote: 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!!! :) |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com