Price discount in % in an Excel table
Solved
sophie38140
Posted messages
3
Status
Member
-
fabien25000 Posted messages 697 Status Member -
fabien25000 Posted messages 697 Status Member -
Hello,
I need to apply a 32% discount on a unit price.
In my Excel table, there are 4 columns:
1 = reference
2 = quantity
3 = unit price
4 = total price (2*3)
My table has 2,596 rows!
I need to do a simple and quick calculation.
Thank you in advance for your responses.
I need to apply a 32% discount on a unit price.
In my Excel table, there are 4 columns:
1 = reference
2 = quantity
3 = unit price
4 = total price (2*3)
My table has 2,596 rows!
I need to do a simple and quick calculation.
Thank you in advance for your responses.
2 answers
-
Hello,
this request isn't very clear.. do you need to apply a 32% discount on the 2596 lines of the unit price column?
--
When you only have a hammer, all problems look like a nail. -
Hello
if you want to keep the unit price intact:- copy it and paste it into an empty column
- enter 0.68 in an empty cell
- select the price field
- right-click / special paste and "Multiply"
this will give you the new price
you can of course do this directly on the Price column
but if you want to calculate with a formula:
for the unit price in a new column:
=C2*0.68
and to get the result of the reduced total price directly:
=C2*B2*0.68
kind regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
