Excel discount

Hi,

I have a column that I would like to apply a percentage discount too in excel, I'd like the user to be able to change the percentage discount by simply entering a new number in a cell, say for example today he wants to add a 10% discount to all prices in column D, when he types in the number the new prices in column D now have the discounted price.

also would it be possible for him to change the price in one cell of column D while always keeping the discounted price? Say he says today he feels like the toaster will 300$, he types in 300 in one of the cells in column D, then the 300 gets mutiplied by the discounted number in the other cell?

Thank you,
FCapoAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
Assuming Base Price in D2 and discount as percentage in F1, in E2:

=D2*(1+$F$1)

If user wants option available to apply discount to some lines and not others, have column with Y or N option, eg Column G:

=D2+IF(G2="Y",D2*$F$1,0)

Thanks
Rob H
0
 
Rory ArchibaldCommented:
It would be simple if you can use a separate column for the discounted price. Then you can just use a formula like:
=D2*(1-$G$1%)

where he enters say 10 in G1.

If you really want the original values in column D to change (I would not recommend it), you would need code.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.