Forum Discussion
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 ...
If I can recommend you add a file (without sensitive data) to your request.
This way you could get an answer much faster and more precisely.
Why does someone who wants to help have to create an example file
if the person who helped doesn't bother to create one himself?
Knowledge of the Excel version and the operating system would be an advantage.
Thank you for your understanding and patience
Nikolino
The more I know, the more I realize that I don't know anything.
(Albert Einstein freely based on Socrates)
- Hi Nikolino, thank you for your suggestion. I exported a section of the Excel file in PDF I am creating. I will upload it to my post.
- 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 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.
