Create a Formula to Calculate the Price Reduction or Discount.

Posted on March 31, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Create a Formula to Calculate the Price Reduction or Discount.

Hi folks, I hope you all had a great weekend and that you are ready for some cool Tricks. Well, I don’t have any cool tricks lined up for you this week. As I’ve told you last Friday I had planned for this week some very useful Excel formulas and for Wednesday ready another Outlook tutorial.

We are going to create an easy to work with formula for calculating the price reductions or discounts of a specified product range.

Follow the next steps to calculate the price reduction.

· First step is to create a spreadsheet kind of similar as this one.

Formula-calculate-price-reduction-pic1

· Then select Cell C1 and Type in -20%

Formula-calculate-price-reduction-pic2

· Now select Cells C5:C10

· And type in the following formula =B5+(B5*$C$1)

Formula-calculate-price-reduction-pic3

· And press CTRL+ENTER

Formula-calculate-price-reduction-pic4

And you’re done; you’ll now have a list with all the net prices. I hope you’ve found this formula useful and I hope you’ll stay tuned for tomorrows Excel Tip, Trick or Formula. See you tomorrow!!

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.