How To Use Excel Formula For Percentage While Working

Asked By Johnson Melanie 0 points N/A Posted on - 11/02/2017

I am a student, and I don’t know how to calculate percentages in excel. I have to work on a project in which I have to calculate, and I am not able to do it. What is the excel formula for percentage calculation?

• Status: Open
• Question Views: 191
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: excel formula

Answered By MrMarshall Johnny 10 points N/A #305696

How To Use Excel Formula For Percentage While Working

Calculating percentages in excel is a very easy task. There are particular formulas to every calculation in excel, and if you remember them, then you will be able to calculate and make your project perfectly. The percentage calculation is a very task to conduct but what is important to remember the particular formula used. Here are the steps to be followed in excel formula for percentage calculation –

1.) List down all the calculations and readings you have taken required for the percentage calculation in their respective cells to manage your data in the worksheet.

2.) Select the cell where you want to get your percentage calculated.

3.) Let us suppose that you have the used quantity as B1 and the total quantity as A1. So the formula required for the calculation will be =B1/A1.

4.) Now, your percentage for the particular cell has been calculated. If you want to calculate for more than two terms, then just start the formula with = and mention the cells you want to choose for calculation in the formula.

 

About MrMarshall Johnny

Questions
17

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/02/2017
• Question Category: Software Others