Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate discounts within a pricelist
Help -- I have tried but I am not as familiar as I would like to be with the
formulas. I have a pricelist with 2250 items (rows) I would like to take the list prices from column I and multiply by the discount and show the individual net prices in column J. I can make a simple product fomula for each row separetely but is there a way to do it globally? |
#2
|
|||
|
|||
Hi Old Cowboy Jim,
If I understand you correctly, you would like to change the discount rate and then have all the net amounts in J change at once. I would create a single cell to hold the discount rate and then multiple each cell in column I by that rate using absolute addresses. For example, place your discount rate in Cell A1 or somewhere else out of the way. Then in J10 or whereever your first row of data begins, type the following: =$A$1*I10. After you get the first formula, copy down. Then if your rate changes, just change what is in A1 and all of column J will update. "Oldcowboyjim" wrote: Help -- I have tried but I am not as familiar as I would like to be with the formulas. I have a pricelist with 2250 items (rows) I would like to take the list prices from column I and multiply by the discount and show the individual net prices in column J. I can make a simple product fomula for each row separetely but is there a way to do it globally? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with sumif to calculate column | Excel Discussion (Misc queries) | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |