Applying Discount

Acorn

Board Regular
Is it possible to have a "discount cell"....
Where I could enter in the amount to discount from the total price......
My greatest issue is that the discount is not always the same...

is there a formula that will accept these changes?

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Derek

Well-known Member
Hi there

If you are discounting by a percentage you could try something simple like this:

A1 (formatted General) holds the discount percentage (for 10% discount enter 10)
B1 has the formula =(100-A1)/100
Column C has the undiscounted price of the articles
The discount price in D1 has this formula =\$B\$1*C1 (scroll it down column D)
You can change the value in A1 to reflect any change in the discount percentage

regards
Derek

Egress1

Active Member
Something like this
MasterXL.xls
ABCDEFGHI
1QuantityItemPerItemCostTotalQuantityItemPerItemCostTotal
23Books\$15.25\$45.753Books\$15.25\$45.75
31Markers\$1.00\$1.001Markers\$1.00\$1.00
4
5SubTotal\$46.75SubTotal\$46.75
6DiscountHard-\$10.00DiscountPercent10.00%
7Total\$36.75Total\$42.08
Sheet1

Acorn

Board Regular
there is always something isn't there????

I already have a sum in my total cell =Sum(I4:i22) I have been trying to apply the discount formula to the cell but I either get a "value" or I make it so the formula is null........
How would I apply the formula to the cell? I am using an if or statement but I don't know if that is the proper way to go......

Thank you so much for your help!!!!

Acorn

Acorn

Board Regular
This is the formula I figured to apply a discount when there is a total already summing in the total cell

I named my
subtotal, tax1, tax2 SUBTOTAL
In my total cell I inserted the formula =SUM(subtotal-(subtotal*discount))
and I named my discount cell DISCOUNT

In order to prevent a #value in the total cell remember to use CTRL+SHIFT+ENTER after you enter the formula

It is working for me!!!!

Acorn

Yogi Anand

MrExcel MVP
Hi Acorn:

Good job -- you found a solution to what you were trying to accomplish. However, I did not follow your statement regarding having to use CTRL+SHIFT+ENTER -- that is needed for array formulas only.

Anyway, in the following ... I had a bit of play with what you were trying to do:
y040128h1a.xls
ABCD
1DISCOUNT10%
2
3SubtotalDiscountedAmount
4102.0091.80
5100.0090.00
615.2513.73
Sheet15

In cell C4, the formula is ... =B4*(1-DISCOUNT)

If I misunderstood your statement regarding the use of CTRL+SHIFT+ENTER -- my apologies!

Replies
4
Views
71
Replies
6
Views
75
Replies
10
Views
172
Replies
2
Views
40
Replies
1
Views
77

1,172,049
Messages
5,878,904
Members
433,381
Latest member
rob789

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back