Applying Discount

Acorn

Board Regular
Joined
Sep 3, 2003
Messages
90
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?
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
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
 

Acorn

Board Regular
Joined
Sep 3, 2003
Messages
90
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
Joined
Sep 3, 2003
Messages
90
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
Joined
Mar 12, 2002
Messages
11,454
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,608
Messages
5,597,143
Members
414,129
Latest member
mr vba

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top