{"id":1344,"date":"2012-11-25T19:07:21","date_gmt":"2012-11-25T19:07:21","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1344"},"modified":"2026-01-02T05:27:10","modified_gmt":"2026-01-02T05:27:10","slug":"how-to-calculate-a-percentage-reduction-in-excel-using-formulas","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-calculate-a-percentage-reduction-in-excel-using-formulas\/","title":{"rendered":"How to calculate percentage reduction using Excel formulas"},"content":{"rendered":"<p>One of the many things I like about Excel is that I can set up the formula in one cell and copy it to other cells. It&#8217;s also a favourite for our delegates <a href=\"\/microsoft\/excel-training-london.php\">attending our Excel course London<\/a>.<\/p>\n<p>If I want to apply a percentage reduction to a figure, I can set it up for the first line of data and then autofill the relevant cells. \u00a0With adverts already reminding us to spend for Christmas and plan for the sales, here is a simple example of applying a percentage price reduction in Excel.<\/p>\n<p><strong>Applying the same percentage discount to multiple items<\/strong><br \/>\nA shop wants to calculate discounts of 33% for all sale items in the January sale, and an Excel sheet can set these up easily.<\/p>\n<p>All the items will have a 33% reduction applied on 1st January 2026.<\/p>\n<figure id=\"attachment_1346\" aria-describedby=\"caption-attachment-1346\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/apply-percent-excel-courses-london.png\"><img decoding=\"async\" class=\"wp-image-1346 size-medium\" src=\"\/b\/wp-content\/uploads\/2012\/11\/apply-percent-excel-courses-london-300x146.png\" alt=\"apply-percent-excel-courses-london\" width=\"300\" height=\"146\" \/><\/a><figcaption id=\"caption-attachment-1346\" class=\"wp-caption-text\">I create a formula using the data in B2 and then copy the formula to the remaining cells in the column<\/figcaption><\/figure>\n<p>To set up the formula in the first cell, the price in B2 is selected, and then multiplied by 33%. \u00a0The formula will appear as =B2*33%. \u00a0By clicking enter the discount is applied. \u00a0This formula can now be copied down the column.<\/p>\n<figure id=\"attachment_1347\" aria-describedby=\"caption-attachment-1347\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/fill-percent-excel-courses-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1347\" src=\"\/b\/wp-content\/uploads\/2012\/11\/fill-percent-excel-courses-london-300x121.png\" alt=\"fill-percent-excel-courses-london\" width=\"300\" height=\"121\" \/><\/a><figcaption id=\"caption-attachment-1347\" class=\"wp-caption-text\">Use the autofill handle to copy the formula in the remaining cells.<\/figcaption><\/figure>\n<p>If the shop now wants to work out the new price, they can add an extra column and take the sale reduction from the original price using a formula.<\/p>\n<figure id=\"attachment_1348\" aria-describedby=\"caption-attachment-1348\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/new-price-column-excel-courses-training.png\"><img decoding=\"async\" class=\"size-medium wp-image-1348\" src=\"\/b\/wp-content\/uploads\/2012\/11\/new-price-column-excel-courses-training-300x107.png\" alt=\"new-price-column-excel-courses-training\" width=\"300\" height=\"107\" \/><\/a><figcaption id=\"caption-attachment-1348\" class=\"wp-caption-text\">Simple formula applied to calculate the new price.<\/figcaption><\/figure>\n<p>In Column D, the calculation is the original price in column B2 minus the sale reduction in C2.\u00a0 So the formula is =B2-C2. \u00a0This formula is then autofilled down the remaining cells and the new price is updated.<\/p>\n<p>This works well, when you have a same percentage discount applied to a group of items.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the many things I like about Excel is that I can set up the formula in one cell and copy it to other cells. It&#8217;s also a favourite for our delegates attending our Excel course London. If I want to apply a percentage reduction to a figure, I can set it up for [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[194,414],"class_list":["post-1344","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-courses-london-vlookup-pivot-tables","tag-percentage-formulas"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1344"}],"version-history":[{"count":4,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1344\/revisions"}],"predecessor-version":[{"id":7824,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1344\/revisions\/7824"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}