Forum Discussion
assigning same percentage discount to four different columns with different prices
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)
- NikolinoDEMar 05, 2021Platinum ContributorPDF does not help, is difficult or impossible to edit, must already be in Excel.
Thank you for your understanding and patience.
Nikolino- CanarianMar 05, 2021Copper ContributorThank 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.- 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)