Doing a Straw Poll with results to ten yes/no questions
Picture 1 column for yes responses, 1 column for no responses, the total number of responses is a variable.
Now I need to develop a percentage cell for yes and a percentage cell for no responses and the formula for each of these is absolutely beyond me. Though I really can do basic formulas.
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
Posted on Aug 09, 2008
Oct 24, 2017 | Math
May 15, 2017 | Facebook Computers & Internet
Jan 19, 2016 | Computers & Internet
Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.
Example
The example may be easier to understand if you copy it to a blank
worksheet.
Apr 30, 2011 | Computers & Internet
Sep 23, 2009 | Computers & Internet
May 14, 2009 | Microsoft Office Excel 2007
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Jan 03, 2009 | Microsoft Computers & Internet
Mar 25, 2008 | Microsoft Excel for PC
Sep 09, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
352 people viewed this question
Usually answered in minutes!
×