Forum Discussion
Canarian
Mar 04, 2021Copper Contributor
assigning same percentage discount to four different columns with different prices
I have a question. I am setting up an cost estimating spreadsheet. I have the same product prices configured 6 different ways on six columns with multiple rows also configured differently. I want to ...
NikolinoDE
Mar 05, 2021Platinum Contributor
PDF does not help, is difficult or impossible to edit, must already be in Excel.
Thank you for your understanding and patience.
Nikolino
Thank you for your understanding and patience.
Nikolino
Canarian
Mar 05, 2021Copper Contributor
Thank you Nikolino. I copied and pasted to a new work book the part where the issue I asked for help is. I cannot send you the original file which I have saved it on three different drivers for safety.
The original file contains proprietary info. The formulas are all discombobulated because some of the referenced cells are not present on this sample. In this sample you'll see the description of the product (column A), columns H through M are four columns where different configuration prices are for the listed products. Columns Q through AO, are the discounts I wanted to apply to the products based on quantity. As you can see I had to created 6 columns (10% through 30%) for each different product configuration so I have 26 columns. Although it is not difficult to cut and paste the formulas, I had to go through each cell to make sure the proper referenced cells were correct and to make the necessary adjustments . Spent too much time doing this and was looking for a simpler process. This is an estimating spreadsheet for a small print shop.
I will place the file on the original post.
Thank you.
The original file contains proprietary info. The formulas are all discombobulated because some of the referenced cells are not present on this sample. In this sample you'll see the description of the product (column A), columns H through M are four columns where different configuration prices are for the listed products. Columns Q through AO, are the discounts I wanted to apply to the products based on quantity. As you can see I had to created 6 columns (10% through 30%) for each different product configuration so I have 26 columns. Although it is not difficult to cut and paste the formulas, I had to go through each cell to make sure the proper referenced cells were correct and to make the necessary adjustments . Spent too much time doing this and was looking for a simpler process. This is an estimating spreadsheet for a small print shop.
I will place the file on the original post.
Thank you.
- NikolinoDEMar 06, 2021Platinum Contributor
How to do percentages in Excel
How to calculate discounts in Excel
Here is some information about what I can offer you at the moment.
Unfortunately, I don't have more time.
I wish you a lot of fun with Ecel.
Give a man a fish and you will feed him for a day. Teach a man to fish and you will feed him for life.
(Konfuzius *551 v. Chr. †479 v. Chr. Chinesicher Philosoph)
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)