Question about Microsoft Excel for PC
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!
Posted on Aug 09, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
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
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
342 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: