# How to Calculate Percentage in excel

0
326

How to Calculate Percentage in excel

To show a number as a percent in Excel, you need to apply the Percentage format to the cells.

Simply select the cells to format, and then click the Percent Style (%) button in the Number group on the ribbon’s Home tab.

You can then increase (or decrease) the the decimical place as needed. (See Rounding issues below for more information.)

#### Negative percentages

If you want negative percentages to be formatted differently—for example, to appear as red text or within parentheses—you can create a custom number format such as 0.00%;[Red]-0.00% or 0.00%_);(0.00%).

#### Calculating percentages

As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The basic formula for calculating a percentage is =part/total.

In the example below, Actual Points/Possible Points = Grade %:

Say you want to reduce a particular amount by 25%, like when you’re trying to apply a discount.

Here, the formula will be: =Price*1-Discount %. (Think of the “1” as a stand-in for 100%.)