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

    How to Get the Percent of a Number in Excel

    • |
    • 0 step |
    • 34 seconds
      To begin, open your workbook in Excel.

      Entering a Percent

      Click the cell where you want to enter the percentage of a number.
      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

      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]]
      Apply the formula to other cells by clicking and dragging the small rectangle at the bottom right corner of the cell.
      Was this Scribe helpful?
      Save this document for future reference.
      click-target-circles-background
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe