{"id":40042,"date":"2024-03-18T19:34:06","date_gmt":"2024-03-18T18:34:06","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=40042"},"modified":"2024-04-26T20:30:35","modified_gmt":"2024-04-26T18:30:35","slug":"what-is-20-of-40-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/","title":{"rendered":"What is 20 of 40 in Excel: Quick Percentage of Number Formula Guide"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-40275 size-large\" title=\"What is 20 of 40 in excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel-1024x576.png\" alt=\"What is 20 of 40 in excel\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/What-is-20-of-40-in-excel.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>, the computational wizard, demystifies the process of calculating percentages, transforming what seems like a daunting task into a straightforward and error-free procedure. By understanding percentages as fractions of 100 and utilizing Excel&#8217;s built-in formulas, users can quickly determine values such as what is 20 of 40, streamlining tasks like budget preparation, data analysis, and test grading.<\/p>\n<h3>Key Takeaways<\/h3>\n<ul>\n<li>Percentages represent a part of a whole as a fraction of 100, simplifying the comparison and calculation of different quantities.<\/li>\n<li>Excel&#8217;s built-in formulas and percentage formatting options make percentage calculations swift, accurate, and visually clear, enhancing both efficiency and professionalism.<\/li>\n<li>The basic formula for calculating percentages in Excel is straightforward: =(Part\/Total)*100, with Excel handling the multiplication by 100 automatically.<\/li>\n<li>Excel allows for easy percentage formatting either through ribbon options for quick application or the &#8216;Format Cells&#8217; dialog box for customized displays, including the option to highlight negative percentages in red.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#Unlock_the_Mystery_of_Percentages_in_Excel\" title=\"Unlock the Mystery of Percentages in Excel\">Unlock the Mystery of Percentages in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#Laying_the_Foundations_Percentage_Basics\" title=\"Laying the Foundations: Percentage Basics\">Laying the Foundations: Percentage Basics<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#Step-by-Step_Guide_to_Calculate_20_of_40\" title=\"Step-by-Step Guide to Calculate 20 of 40\">Step-by-Step Guide to Calculate 20 of 40<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#Visual_Aids_Formatting_Cells_for_Clearer_Results\" title=\"Visual Aids: Formatting Cells for Clearer Results\">Visual Aids: Formatting Cells for Clearer Results<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#Beyond_the_Basics_Adapting_Formulas_for_Various_Scenarios\" title=\"Beyond the Basics: Adapting Formulas for Various Scenarios\">Beyond the Basics: Adapting Formulas for Various Scenarios<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/what-is-20-of-40-in-excel\/#FAQs_Your_Questions_Answered\" title=\"FAQs: Your Questions, Answered\">FAQs: Your Questions, Answered<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Unlock_the_Mystery_of_Percentages_in_Excel\"><\/span>Unlock the Mystery of Percentages in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Introduction to Percentage Calculations in Excel<\/h3>\n<p>Have you ever found yourself scratching your head wondering how to calculate something like &#8220;what is 20 of 40?&#8221; Especially when it comes to wrangling <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/percentage-of-goal\/\" target=\"_blank\" rel=\"noopener\">percentages<\/a>. You&#8217;re not alone. Percentages can seem mysterious, but they&#8217;re a piece of cake with the right tools. Excel is that trusty sidekick that makes these calculations swift and painless.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Laying_the_Foundations_Percentage_Basics\"><\/span>Laying the Foundations: Percentage Basics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding What Percentage Represents<\/h3>\n<p>Percentage can sometimes feel like a math puzzle where you&#8217;re juggling numbers in a cloud of confusion. But fret not, it&#8217;s much simpler than it seems. Think of a percentage as a way to express a number as a fraction of 100. If you picture a big pie cut into 100 slices, a percentage tells you how many of those slices you have. In your quest to figure out &#8220;what is 20 of 40,&#8221; you&#8217;re asking how big a slice of a 100-piece pie you&#8217;d have if 40 was the whole pie.<\/p>\n<h3>The Role of Excel in Simplifying Percentage Calculations<\/h3>\n<p>Excel shines as a computational wizard, turning the daunting task of percentage calculations into a walk in the park. You can bid farewell to the days of manual crunching of numbers with a calculator. Through its built-in formulas, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-11-20-as-a-percent\/\" target=\"_blank\" rel=\"noopener\">Excel not only calculates percentages<\/a> swiftly but also ensures accuracy every time you deal with data. Whether you are preparing a budget, analyzing data sets, or grading tests, Excel streamlines the process, saving you time and reducing errors.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-by-Step_Guide_to_Calculate_20_of_40\"><\/span><span style=\"color: var(--lumo-header-text-color);font-size: calc(var(--editor-zoom-font-size) + 22px);font-weight: bold;letter-spacing: 0.04em;font-family: inherit\">Step-by-Step Guide to Calculate 20 of 40<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Inputting Your Numbers Correctly<\/h3>\n<p>Before diving into the formula, getting the numbers right in Excel is crucial. Start by entering the number from which you want to calculate the percentage (in this case, 40) into a cell\u2014let&#8217;s say A2. Then, in another cell B2, you&#8217;ll need to input the percentage you wish to calculate (20).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A503A22.376957_What_is_20_of_40_in_Excel_6.png\" alt=\"what is 20 of 40\" width=\"521\" height=\"358\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>Using the Basic Excel Percentage Formula<\/h3>\n<p>To reveal the magic number &#8212; what 20 is of 40 in Excel &#8212; we will employ the basic Excel percentage formula. This formula is a breeze: =(Part\/Total)*100. Here&#8217;s how you do it:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>In your Excel worksheet, let&#8217;s assume cell A2 holds the total (40), and B2 holds the part (20).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A533A07.679295_What_is_20_of_40_in_Excel_6.png\" alt=\"what is 20 of 40\" width=\"521\" height=\"358\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Click on an empty cell, say C2, where you want the result to appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A533A58.050287_What_is_20_of_40_in_Excel_5.png\" alt=\"what is 20 of 40\" width=\"522\" height=\"318\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Type in the formula <code>=B2\/A2<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A543A18.189981_What_is_20_of_40_in_Excel_7.png\" alt=\"what is 20 of 40\" width=\"528\" height=\"264\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Then, apply percentage formatting: Select the cell with the result, go to the \u2018Home\u2019 tab, and under the \u2018Number\u2019 group, click on the percent symbol <code>%<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A543A25.966646_What_is_20_of_40_in_Excel_8.png\" alt=\"what is 20 of 40\" width=\"1236\" height=\"783\" \/><\/p>\n<p>Voila! Excel automatically multiplies by 100 and shows you the answer \u2013 it&#8217;s 50%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T203A543A34.757490_What_is_20_of_40_in_Excel_9.png\" alt=\"what is 20 of 40\" width=\"519\" height=\"329\" \/><\/p>\n<p><span style=\"font-size: calc(var(--editor-zoom-font-size) + var(--lumo-font-size-m));letter-spacing: 0.04em;font-family: inherit;color: var(--lumo-body-text-color)\">Thus, 20 out of 40 is 50%, as accessible as a warm knife through butter with Excel doing the heavy lifting.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Visual_Aids_Formatting_Cells_for_Clearer_Results\"><\/span>Visual Aids: Formatting Cells for Clearer Results<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Method 1 &#8211; Applying Percentage Formatting via Ribbon Options<\/h3>\n<p>Excel offers a neat and swift way to transform your data into percentages using the ribbon options. Here\u2019s how you glide through this process:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Select the cell or range of cells where you&#8217;ve performed your calculations.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A143A10.809254_What_is_20_of_40_in_Excel_10.png\" alt=\"what is 20 of 40\" width=\"524\" height=\"336\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> On the Home tab, look for the &#8216;Number&#8217; group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A163A22.388826_What_is_20_of_40_in_Excel_11.png\" alt=\"what is 20 of 40\" width=\"1415\" height=\"164\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Click on the Percentage Style button, a symbol with &#8220;%&#8221;, to instantly convert your selected numbers into percentages.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A163A14.057926_What_is_20_of_40_in_Excel_18.png\" alt=\"what is 20 of 40\" width=\"1237\" height=\"435\" \/><\/p>\n<p>This one-click wonder not only saves time but adds professionalism to your data presentation, transforming 0.5 to 50% just like that.<\/p>\n<p>&nbsp;<\/p>\n<h3>Method 2 &#8211; Customizing Through the Format Cells Dialog Box<\/h3>\n<p>If you crave more control over how your percentages look, or if you&#8217;re using an older Excel version without the ribbon, the &#8216;Format Cells&#8217; dialog box is your ticket to customization. Here\u2019s the play-by-play:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Highlight the cell(s) where you want to showcase a percentage.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A173A13.157078_What_is_20_of_40_in_Excel_10.png\" alt=\"what is 20 of 40\" width=\"524\" height=\"336\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Right-click and choose &#8216;Format Cells\u2026&#8217;, or press <code>Ctrl+1<\/code> for a keyboard shortcut to the dialog box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A173A57.727850_What_is_20_of_40_in_Excel_19.png\" alt=\"what is 20 of 40\" width=\"1023\" height=\"963\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Click on the Number tab, then select &#8216;Percentage&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A183A29.617847_What_is_20_of_40_in_Excel_12.png\" alt=\"what is 20 of 40\" width=\"673\" height=\"625\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> For a precise display, pick the number of decimal places you fancy.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A183A37.677096_What_is_20_of_40_in_Excel_13.png\" alt=\"what is 20 of 40\" width=\"674\" height=\"623\" \/><\/p>\n<p>If it&#8217;s drama you&#8217;re after, you can set negative percentages to show up in red by choosing a Custom format like <code>0%;[Red]-0%<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A183A49.676208_What_is_20_of_40_in_Excel_14.png\" alt=\"what is 20 of 40\" width=\"1049\" height=\"731\" \/><\/p>\n<p>After clicking OK, your cells will dress up in the formatting you picked out, and you&#8217;re set for the show.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Beyond_the_Basics_Adapting_Formulas_for_Various_Scenarios\"><\/span>Beyond the Basics: Adapting Formulas for Various Scenarios<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Increasing a Number by a Percentage<\/h3>\n<p>If your spreadsheet quest involves increasing a number by a percentage, you&#8217;re navigating familiar territory with Excel&#8217;s nifty formulae. Here\u2019s how you conquer those calculations:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Place the original number in a cell (let&#8217;s call it cell A2).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A183A59.973004_What_is_20_of_40_in_Excel_15.png\" alt=\"what is 20 of 40\" width=\"448\" height=\"349\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Enter the percentage increase in another cell as a decimal (for instance, for 20%, you&#8217;d enter 0.20 in cell B2).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A203A12.238472_What_is_20_of_40_in_Excel_21.png\" alt=\"what is 20 of 40\" width=\"527\" height=\"319\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> In a different cell, harness the power of Excel&#8217;s formula: <code>=A2*(1+B2)<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A203A24.498487_What_is_20_of_40_in_Excel_16.png\" alt=\"what is 20 of 40\" width=\"517\" height=\"303\" \/><\/p>\n<p>Excel enchants the original number, increasing it by 20% and displaying the new value right before your eyes.<\/p>\n<p>This sorcery makes tasks like adjusting prices or calculating interest gains as easy as pie.<\/p>\n<p>&nbsp;<\/p>\n<h3>Figuring Out Percentage Decrease with Excel Formulas<\/h3>\n<p>Have you ever been in need to adjust numbers downward by a percentage? Maybe you&#8217;re calculating discounts or estimating expense reductions. Excel has got you covered yet again. Here&#8217;s the straightforward spell for lowering those figures:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Start with the number you want to decrease in cell A2.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A203A32.443560_What_is_20_of_40_in_Excel_15.png\" alt=\"what is 20 of 40\" width=\"448\" height=\"349\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Next, jot down the percentage of the decrease as a decimal in cell B2. For example, a decrease of 20% would appear as 0.20.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A203A38.755058_What_is_20_of_40_in_Excel_21.png\" alt=\"what is 20 of 40\" width=\"527\" height=\"319\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Now, weave together the formula in cell C2: <code>=A2*(1-B2)<\/code>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"what is 20 of 40\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/03\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia634831232024-03-14T213A203A49.425237_What_is_20_of_40_in_Excel_17.png\" alt=\"what is 20 of 40\" width=\"518\" height=\"311\" \/><\/p>\n<p>With the charm of a formulaic wand wave, Excel shrinks the original number by the given percentage, presenting you with the lesser amount.<\/p>\n<p>This formula ensures that whether you&#8217;re marking down prices or trimming a budget, Excel subtracts just the right amount of fairy dust from your figures.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"FAQs_Your_Questions_Answered\"><\/span>FAQs: Your Questions, Answered<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>How do you <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/format-numbers-as-percentages-de49167b-d603-4450-bcaa-31fba6c7b6b4#:~:text=Percentages%20are%20calculated%20by%20using,be%20correctly%20displayed%20as%2010%25.\" target=\"_blank\" rel=\"nofollow noopener\">calculate percentages<\/a> using simple formulas?<\/h3>\n<p>To calculate percentages using simple formulas in Excel, enter the formula <code>=(Part\/Whole)*100<\/code> into a cell. Replace &#8216;Part&#8217; with the cell reference of the part and &#8216;Whole&#8217; with the cell reference of the whole. Excel will spit out the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/yes-no-dropdown\/\" target=\"_blank\" rel=\"noopener\">percentage<\/a> value for you.<\/p>\n<h3>Can Excel automatically calculate percentage increases or decreases?<\/h3>\n<p>Yes, Excel can automatically calculate percentage increases or decreases. For an increase, use <code>=Original_Number*(1+Percentage)<\/code> and for a decrease, use <code>=Original_Number*(1-Percentage)<\/code>, where &#8216;Percentage&#8217; is the percentage change written in decimal form.<\/p>\n<h3>How do I calculate 20% of a number in Excel?<\/h3>\n<p>To calculate 20% of a number in Excel, you can use the formula `=number*0.2`, replacing &#8220;number&#8221; with the actual value you&#8217;re interested in. Alternatively, you could also use the formula `=20%*number`, and Excel will automatically interpret the 20% as 0.2 to perform the calculation.<\/p>\n<h3>How do you take 20% off a price in Excel?<\/h3>\n<p>To take 20% off a price in Excel, input the original price in a cell (e.g., A1), and in a neighboring cell, use the formula `=A1*(1-20%)`. Press &#8216;Enter&#8217;, and the cell will display the price after subtracting the 20% discount. If working with a list of prices, drag the fill handle down to apply this formula to the entire column.<\/p>\n<h3>How do you do 40% discount in Excel?<\/h3>\n<p>To apply a 40% discount in Excel, first ensure column A contains the original prices. Then, choose a blank cell where you will apply the formula =A2*(1-0.40) to calculate the discounted price. Press &#8216;Enter&#8217; and drag the fill handle down to apply the 40% discount to all items listed. After the formula is applied, the cells will reflect the sale prices after a 40% reduction.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn to easily calculate percentages in Excel with our guide. From basic formulas to advanced tricks, boost your number-crunching skills today!<\/p>\n","protected":false},"author":1,"featured_media":40275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"What is 20 of 40 in Excel: Quick Percentage of Number Formula Guide","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3],"tags":[2093,2094,2092],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/40042"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=40042"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/40042\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/40275"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=40042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=40042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=40042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}