{"id":1797,"date":"2012-02-08T12:05:31","date_gmt":"2012-02-08T12:05:31","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=543"},"modified":"2024-05-12T01:22:55","modified_gmt":"2024-05-12T01:22:55","slug":"using-percentages-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-percentages-in-excel-2010\/","title":{"rendered":"Using Percentages in Excel 2010"},"content":{"rendered":"

<\/a>Calculate the percentage if you know the total and amount<\/h2>\n

For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?<\/p>\n

Example<\/h3>\n

The example may be easier to understand if you copy it to a blank worksheet.<\/p>\n

\n
    \n
  1. Create a blank workbook or worksheet.<\/li>\n
  2. Select the example in the Help topic.<\/li>\n<\/ol>\n

    \u00a0Note\u00a0<\/strong>\u00a0\u00a0Do not select the row or column headers.<\/p>\n

    Selecting an example from Help<\/div>\n
      \n
    1. Press CTRL+C.<\/li>\n
    2. In the worksheet, select cell A1, and press CTRL+V.<\/li>\n
    3. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas<\/strong> tab, in the Formula Auditing<\/strong> group, click the Show Formulas<\/strong> button.<\/li>\n<\/ol>\n<\/div>\n\n\n\n
      \n
      \n\n\n\n\n\n
      <\/td>\n<\/tr>\n
      1<\/strong><\/th>\n<\/tr>\n
      2<\/strong><\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n\n
      \n\n\n\n\n\n\n\n
      A<\/strong><\/th>\nB<\/strong><\/th>\n<\/tr>\n
      Points answered correctly<\/strong><\/td>\nTotal points possible<\/strong><\/td>\n<\/tr>\n
      42<\/td>\n50<\/td>\n<\/tr>\n
      Formula<\/strong><\/td>\nDescription (Result)<\/strong><\/td>\n<\/tr>\n
      =A2\/B2<\/td>\nDivides 42 by 50 to find the percentage of correct answers (0.84 or 84%)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      \u00a0Note\u00a0<\/strong>\u00a0\u00a0You can view the number as a percentage. Select the cell, and then on the Home<\/strong> tab, in the Number<\/strong> group, click Percent Style<\/strong> .<\/p>\n

      <\/a><\/p>\n

      <\/a>Calculate the total if you know the amount and percentage<\/h2>\n

      For example, the sale price of a shirt is $15, which is 25% off the original price. What is the original price? In this example, you want to find 75% of which number equals 15.<\/p>\n

      Example<\/h3>\n

      The example may be easier to understand if you copy it to a blank worksheet.<\/p>\n

      \n
        \n
      1. Create a blank workbook or worksheet.<\/li>\n
      2. Select the example in the Help topic.<\/li>\n<\/ol>\n

        \u00a0Note\u00a0<\/strong>\u00a0\u00a0Do not select the row or column headers.<\/p>\n

        Selecting an example from Help<\/div>\n
          \n
        1. Press CTRL+C.<\/li>\n
        2. In the worksheet, select cell A1, and press CTRL+V.<\/li>\n
        3. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas<\/strong> tab, in the Formula Auditing<\/strong> group, click the Show Formulas<\/strong> button.<\/li>\n<\/ol>\n<\/div>\n\n\n\n
          \n
          \n\n\n\n\n\n
          <\/td>\n<\/tr>\n
          1<\/strong><\/th>\n<\/tr>\n
          2<\/strong><\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n\n
          \n\n\n\n\n\n\n\n
          A<\/strong><\/th>\nB<\/strong><\/th>\n<\/tr>\n
          Sale price<\/strong><\/td>\n100% minus the discount (in decimal form)<\/strong><\/td>\n<\/tr>\n
          15<\/td>\n0.75<\/td>\n<\/tr>\n
          Formula<\/strong><\/td>\nDescription (Result)<\/strong><\/td>\n<\/tr>\n
          =A2\/B2<\/td>\nDivides 15 by 0.75 to find the original price (20)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          <\/a><\/p>\n

          <\/a>Calculate the difference between two numbers as a percentage<\/h2>\n

          For example, your earnings are $2,342 in November and $2,500 in December. What is the percentage change in your earnings between these two months? To do this task, use the ABS function and the subtraction (-) and division (\/) operators.<\/p>\n

          Example<\/h3>\n

          The example may be easier to understand if you copy it to a blank worksheet.<\/p>\n

          \n
            \n
          1. Create a blank workbook or worksheet.<\/li>\n
          2. Select the example in the Help topic.<\/li>\n<\/ol>\n

            \u00a0Note\u00a0<\/strong>\u00a0\u00a0Do not select the row or column headers.<\/p>\n

            Selecting an example from Help<\/div>\n
              \n
            1. Press CTRL+C.<\/li>\n
            2. In the worksheet, select cell A1, and press CTRL+V.<\/li>\n
            3. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas<\/strong> tab, in the Formula Auditing<\/strong> group, click the Show Formulas<\/strong> button.<\/li>\n<\/ol>\n<\/div>\n\n\n\n
              \n
              \n\n\n\n\n\n
              <\/td>\n<\/tr>\n
              1<\/strong><\/th>\n<\/tr>\n
              2<\/strong><\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n\n
              \n\n\n\n\n\n\n\n
              A<\/strong><\/th>\nB<\/strong><\/th>\n<\/tr>\n
              November earnings<\/strong><\/td>\nDecember earnings<\/strong><\/td>\n<\/tr>\n
              2342<\/td>\n2500<\/td>\n<\/tr>\n
              Formula<\/strong><\/td>\nDescription (Result)<\/strong><\/td>\n<\/tr>\n
              =(B2-A2)\/ABS(A2)<\/td>\nDivides the difference between the second and first numbers by the absolute value of the first number to get the percentage change (0.06746 or 6.75%)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

              \u00a0Note\u00a0<\/strong>\u00a0\u00a0You can view the number as a percentage. Select the cell, and then on the Home<\/strong> tab, in the Number<\/strong> group, click Percent Style<\/strong> .<\/p>\n

              Function details<\/h3>\n

              The ABS function returns the absolute value of a number. The absolute value of a number is the number without its sign.<\/p>\n

              <\/a><\/p>\n

              <\/a>Increase or decrease a number by a percentage<\/h2>\n

              For example, you spend an average of $25 on food each week, and you want to cut your weekly food expenditures by 25%. How much can you spend? Or, if you want to increase your weekly food allowance of $25 by 25%, what is your new weekly allowance?<\/p>\n

              Example<\/h3>\n

              The example may be easier to understand if you copy it to a blank worksheet.<\/p>\n

              \n
                \n
              1. Create a blank workbook or worksheet.<\/li>\n
              2. Select the example in the Help topic.<\/li>\n<\/ol>\n

                \u00a0Note\u00a0<\/strong>\u00a0\u00a0Do not select the row or column headers.<\/p>\n

                Selecting an example from Help<\/div>\n
                  \n
                1. Press CTRL+C.<\/li>\n
                2. In the worksheet, select cell A1, and press CTRL+V.<\/li>\n
                3. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas<\/strong> tab, in the Formula Auditing<\/strong> group, click the Show Formulas<\/strong> button.<\/li>\n<\/ol>\n<\/div>\n\n\n\n
                  \n
                  \n\n\n\n\n\n
                  <\/td>\n<\/tr>\n
                  1<\/strong><\/th>\n<\/tr>\n
                  2<\/strong><\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n\n
                  \n\n\n\n\n\n\n\n\n\n
                  A<\/strong><\/th>\nB<\/strong><\/th>\n<\/tr>\n
                  Number<\/strong><\/td>\nPercentage<\/strong><\/td>\n<\/tr>\n
                  25<\/td>\n25%<\/td>\n<\/tr>\n
                  Formula<\/strong><\/td>\nDescription (Result)<\/strong><\/td>\n<\/tr>\n
                  =A2*(1-B2)<\/td>\nDecreases 25 by 25% (18.75)<\/td>\n<\/tr>\n
                  =A2*(1+B2)<\/td>\nIncreases 25 by 25% (31.25)<\/td>\n<\/tr>\n
                  =A2*(1+35%)<\/td>\nIncreases 25 by 35% (33.75)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                  \u00a0Note\u00a0<\/strong>\u00a0\u00a0When you type a number followed by a percent sign (%), the number is interpreted as a hundredth of its value. For example, 5% is interpreted as .05.<\/p>\n","protected":false},"excerpt":{"rendered":"

                  Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers? Example The example may be easier to understand if you copy it to a blank worksheet. Create a blank workbook or worksheet. Select the example in the […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[433,563],"class_list":["post-1797","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-pr","tag-using-percentages-in-excel-2010"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1797","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=1797"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1797\/revisions"}],"predecessor-version":[{"id":7546,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1797\/revisions\/7546"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}