How to calculate discount percentage formula in excel

Today we’ll be talking about how to calculate discount percentages in Excel in a quick and easy way.

Let’s get into it right now!

Would you rather watch this tutorial? Click the play button below!

How to Format the Cell as Percentage

To calculate a discount percentage in Excel, first select the cell where you’re planning to show the result.

Then go to the Home tab and format the cell as Percentage using this ‘Percent Style’ button. This way you’ll make sure Excel will display the results as a percentage, including the per cent sign.

How to Calculate Discount Percentages

Once the cell has been formatted correctly, we type in the equal sign and divide the discounted price in C3 with the original price – the price before the discount was applied – in B3.

When we press Enter, we get the first important result, which tells us that the discounted price (7 euros) is 70% from the original price of 10 euros.

However, we’re trying to calculate the discount, so we need to subtract this calculated figure (70%) from 100%.

In terms of the formula, we need to subtract the first result from the number 1.

So, this is the final formula, which will help you calculate the discount percentage in a quick and easy way.

If the original price was 10 euros and the discounted price is 7 euros, you saved 30%.

And if the discounted price changes to 9 euros, Excel automatically recalculates the discount percentage and shows 10% in the target cell.

The formula works with all numbers and you’ll get the result immediately – couldn’t be quicker and easier!

Don’t miss out a great opportunity to learn:

• How to Calculate Percentage Increase in Excel (The Right Way)
• How to Square a Number in Excel (Two Most Common Ways)
• How to Get Stock Prices in Excel (Free and Automated Solution)

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. &lt;a rel="noreferrer noopener" href="https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1" target="_blank"&gt;Hit that Subscribe button and join the EasyClickers!&lt;/a&gt;&lt;/p&gt;&lt;p&gt;&lt;span id="ezoic-pub-ad-placeholder-120" class="ezoic-adpicker-ad"&gt;&lt;/span&gt;Thanks for watching and I’ll see you in the next tutorial!&lt;/p&gt;&lt;/div&gt;&lt;div class="in_share_element in_share_element_1 blog_share_buttons"&gt;&lt;div class="fb-like" data-href="https://www.easyclickacademy.com/how-to-calculate-discount-percentages-in-excel/" data-layout="button_count" data-action="like" data-show-faces="false" data-share="true"&gt;&lt;/div&gt;&lt;div class="twitter-like"&gt;&lt;a target="_blank" href="https://twitter.com/share" class="twitter-share-button" data-url="https://www.easyclickacademy.com/how-to-calculate-discount-percentages-in-excel/'" data-count="horizontal" data-lang="cs"&gt;Tweet&lt;/a&gt; &lt;script&gt;!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document,'script','twitter-wjs');</p></div></div><div class="related_posts"><div class="related_posts_title title_element_container">Similar posts</div><div class="related_posts_container"><div class="related_post col col-three col-first"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-show-gridlines-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-461x346.png" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Show Gridlines in Excel" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-461x346.png 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-970x727.png 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-297x223.png 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-213x160.png 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/09/How-to-Show-Gridlines-in-Excel-171x128.png 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-show-gridlines-in-excel/">How to Show Gridlines in Excel (Quick and Simple)</a><p>Today we’re going to talk about how to show gridlines in Excel.…</p></div><div class="related_post col col-three"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-insert-the-degree-symbol-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-461x346.png" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Insert Degree Symbol in Excel" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-461x346.png 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-970x727.png 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-297x223.png 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-213x160.png 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Degree-Symbol-in-Excel-171x128.png 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-insert-the-degree-symbol-in-excel/">How to Insert the Degree Symbol in Excel (Two Useful Ways)</a><p>Today we’re going to go through two useful ways how to insert…</p></div><div class="related_post col col-three"><a target="_blank" class="related_post_thumb" href="https://www.easyclickacademy.com/how-to-insert-a-calendar-in-excel/"><img width="461" height="346" src="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-461x346.png" class="attachment-mio_columns_2 size-mio_columns_2 wp-post-image" alt="How to Insert Calendar in Excel" loading="lazy" srcset="https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-461x346.png 461w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-970x727.png 970w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-297x223.png 297w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-213x160.png 213w, https://www.easyclickacademy.com/wp-content/uploads/2022/08/How-to-Insert-Calendar-in-Excel-171x128.png 171w" sizes="(max-width: 461px) 100vw, 461px"></a> <a target="_blank" class="related_post_title title_element_container" href="https://www.easyclickacademy.com/how-to-insert-a-calendar-in-excel/">How to Insert a Calendar in Excel (the Simplest Way)</a><p>Today we’ll be talking about how to insert a calendar in Excel.…</p></div></div></div><div id="blog_comments_container"><div class="commenttitle title_element_container">Comments</div><div class="element_comment_1 blog_comments"><div id="comments" class="comments"><span id="ezoic-pub-ad-placeholder-123" class="ezoic-adpicker-ad"></span><span class="ezoic-ad ezoic-at-2 nativesingle-1 nativesingle-1123 adtester-container adtester-container-123" data-ez-name="easyclickacademy_com-nativesingle-1"><div class="OUTBRAIN" data-ob-contenturl="https://www.easyclickacademy.com/how-to-calculate-discount-percentages-in-excel/" data-ob-installation-key="EZOICL9MFJN21JB32NFBE7ODP" data-external-id="213741_1_123_100x240" data-widget-id="AR_2"></div><div data-expand="100" class="ezlazyload" data-script="//widgets.outbrain.com/outbrain.js"></div></span><div id="respond" class="comment-respond"><h3 id="reply-title" class="comment-reply-title">Add comment <small><a target="_blank" rel="nofollow" id="cancel-comment-reply-link" href="https://www.easyclickacademy.com/how-to-calculate-discount-percentages-in-excel/#respond" style="display:none">Delete answer</a></small></h3><form action="https://www.easyclickacademy.com/wp-comments-post.php" method="post" id="commentform" class="comment-form"><p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message" aria-hidden="true">Required fields are marked <span class="required" aria-hidden="true">*</span></span></p><p class="comment-form-comment"><label for="comment">Comment <span class="required" aria-hidden="true">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required></textarea></p><p class="comment-form-author"><label for="author">Name <span class="required" aria-hidden="true">*</span></label> <input id="author" name="author" size="30" maxlength="245" required></p><p class="comment-form-email"><label for="email">Email <span class="required" aria-hidden="true">*</span></label> <input id="email" name="email" size="30" maxlength="100" aria-describedby="email-notes" required></p><p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" size="30" maxlength="200"></p><p class="mw_field_gdpr_accept"><input type="hidden" value="Your personal information will only be used for the purpose of processing this comment." name="mw_comment_gdpr">Your personal information will only be used for the purpose of processing this comment.</p><p class="form-submit"><input name="submit" type="submit" id="submit" class="ve_content_button ve_content_button_style_x" value="Insert comment"> <input type="hidden" name="comment_post_ID" value="4645" id="comment_post_ID"> <input type="hidden" name="comment_parent" id="comment_parent" value="0"></p><p style="display:none"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="fc647b6971"></p><p style="display:none!important"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="194"><script>document.getElementById("ak_js_1").setAttribute("value",(new Date()).getTime());

What is the formula to calculate discount percentage?

How do you take 10% off in Excel?