I am trying to get the percentage increase between two numbers when one is blank?
SOURCE: Percentages in Excel
No problem, Melinda, I am here to help!
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!
Good Luck!
Regards,
RichMTech
SOURCE: How to add % (Percentage column ) in the excel
The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.
Then you can format the cell to show the number (.2857) as a percentage (28.57%).
SOURCE: HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?
Hi nastyguy3000;
To calculate a percentage in excel you simply take
amount/total = percentage in your cell
Example
A
B
Purchase price
Sales tax (in decimal form)
800
0.089
Formula
Description (Result)
=A2*B2
Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)
Have Fun
Mark
Don't forget to leave a rating.
179 views
Usually answered in minutes!
×