Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for the LESSER of 2 Calculations | Excel Discussion (Misc queries) | |||
Calculations formula | Excel Discussion (Misc queries) | |||
Multiple Calculations in a Formula | Excel Discussion (Misc queries) | |||
Calculations Using the =IF formula | Excel Worksheet Functions | |||
formula to sum all sum calculations in a column | Excel Worksheet Functions |