Create a Formula to Calculate the Price Reduction or Discount.

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

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...


Buzz Up Digg Mixx
Print


Comments

5 Responses to “Create a Formula to Calculate the Price Reduction or Discount.”

  1. Harry Crampton on December 4th, 2009 11:55 pm

    Nice example, easy to follow and understand

  2. Page L. on March 4th, 2010 9:25 am

    thank you very much. This information was very helpful. Is there a way I can get all of the excel formulasm or a list of the formulas?

  3. Cass on April 30th, 2010 2:04 pm

    Nice example very easy to follow and understand. Thank you very much. This was great help.

  4. snowie on July 8th, 2010 5:27 am

    GOOD EXAMPLE, EASY TO LEARN AND UNDERSTAND. IT WAS A GREAT HELP. THANK YOU….

  5. Scotto on August 11th, 2010 7:26 am

    Yo da mang! You have just saved me so much work time and are now my favourite Office website. Keep up the awesome work!

Leave a Reply