- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
All formulas begin with an equals sign (=).
Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division. For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
Other formulas refer to different functions such as SUM, AVERAGE and others. For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
Formulas can be combined with operands. For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
Functions can be nested within each other. For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Sales Product A
Sales Product B
Cost of Sales Product A
Cost of Sales Product B
Total Cost of Sales
If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.
In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK
To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.
I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!