Applying Discount

[Acorn]

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?

 

[Derek]

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]

Something like this

MasterXL.xls
	A	B	C	D	E	F	G	H	I
1	Quantity	Item	PerItemCost	Total		Quantity	Item	PerItemCost	Total
2	3	Books	$15.25	$45.75		3	Books	$15.25	$45.75
3	1	Markers	$1.00	$1.00		1	Markers	$1.00	$1.00
4
5			SubTotal	$46.75				SubTotal	$46.75
6			DiscountHard	-$10.00				DiscountPercent	10.00%
7			Total	$36.75				Total	$42.08
Sheet1

 

[Acorn]

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]

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]

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
	A	B	C	D
1		DISCOUNT	10%
2
3		Subtotal	DiscountedAmount
4		102.00	91.80
5		100.00	90.00
6		15.25	13.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!