How to Get the Percent of a Number in Excel | Scribe

    How to Get the Percent of a Number in Excel

    • |
    • 5 steps |
    • 34 seconds
      1
      To begin, open your workbook in Excel.

      Entering a Percent

      2
      Click the cell where you want to enter the percentage of a number.
      3
      To find 30% of 100, use a formula to multiply 100 by 0.3 (the decimal form of 30%). Type "="\ Click the cell with the number 100.\ Type "\*.3" and press [[Enter]]"

      Using an Existing Percent

      4
      When you already have percents listed in Excel, you can use a formula to multiply to find the percent of a number. In the desired cell, Type "="\ Click the cell with the number.\ Type "\*"\ Click the cell with the percent.\ Press [[Enter]]
      When you already have percents listed in Excel, you can use a formula to multiply to find the percent of a number.

In the desired cell, Type "="\
Click the cell with the number.\
Type "\*"\
Click the cell with the percent.\
Press [[Enter]]
      5
      Apply the formula to other cells by clicking and dragging the small rectangle at the bottom right corner of the cell.
      Apply the formula to other cells by clicking and dragging the small rectangle at the bottom right corner of the cell.