How to Calculate Percentage in excel

0
697
How to Calculate Percentage in excel
How to Calculate Percentage in excel

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.

Also read “How to use whatsapp from a computer”

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%).

Also read “How to Open Aadhar card PDF”

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 %:

How to Calculate Percentage in excel
How to Calculate Percentage in excel

Also read “How to reset your facebook password”

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%.)

How to Calculate Percentage in excel
How to Calculate Percentage in excel

To increase the amount by 25%, simply replace the minus sign in the formula above with a plus sign.

Also read “How to lock WhatsApp With Pattern”

The next example is slightly more complicated. Say the earnings for your department are $2,342 in November and $2,500 in December and you want to find the percentage change in earnings between these two months.

To find the answer, divide the difference between December and November earnings ($158) by the value of the November earning ($2,342).

Also read “Forests Department 226 Forest Guard Bharti”

SHARE
Previous articleHow to Open Aadhar card PDF
Next articleHow to multiply numbers in Excel
Professional Blogger | Web Developer | Certified Publisher Of Google Adsense | Entrepreneur | Web Analyst | Googler | CEO & Founder Of Envisage India Multibiz Private Limited |

LEAVE A REPLY

Please enter your comment!
Please enter your name here