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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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!

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,961
Messages
5,856,531
Members
431,819
Latest member
Tori Murphy

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