Question about Microsoft Business & Productivity Software

1 Answer

% problems Subject 1 Subject 2 Subject 3 Total Percentage Student 1 50 70 40 160 ? Student 2 50 90 50 190 ? Student 3 50 100 60 210 ?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 80 Answers

You need to divide by three and multiply by .01 which will give you the average percetage or you need to divide the total by each entry and get invidual percentages

Posted on Dec 02, 2008

1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

2 Answers

Should I take out a student loan from a bank or a credit union?

Credit union. Credit unions offer low interest rates and a variety of outstanding borrower benefits but you should be a members. Unity One Credit Union in Texas (Unity One Student Loans) was my choice.

Apr 25, 2016 | Business & Productivity Software

2 Answers

What is formula to find percentage of females in my workplace?

      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

      How to do percentages in Excel - Office Blogs

    How to Calculate Percentages in Excel > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet
    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%.

Jan 19, 2016 | Business & Productivity Software

1 Answer

The total snowfall in Buffalo, NY one year was inches. If the total snowfall the following year was inches, what was the percent change? Show and explain your solution.

I don't see any numbers in your question, so let's assume the number of inches in the first year is x and the number of inches in the second year is y. The percentage change is the difference between the number of inches in the second year and the number of inches in the first year, divided by the total number of inches in the first year. This number (which is a fraction) needs to be expressed as a percentage. Algebraically:
y-x is the difference between year 2 and year 1 (can be positive or negative)
x is the total number of inches in year 1
(y-x)/x is the change fraction
(y-x)/x * 100 is the change percentage.

For example, if x = 50 and y = 40 then:
(40-50)/50 * 100 = (-10)/50 * 100 = (-.2) * 100 = -20% = a 20% reduction in snowfall in yr 2 over yr 1.

Feb 09, 2011 | The Learning Company Middle School...

2 Answers


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


Don't forget to leave a rating.

Feb 19, 2009 | Microsoft Business & Productivity Software

1 Answer

Its for calculating the stak ranking

You should use above formula. It will be useful for you.

Feb 04, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

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:

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Business & Productivity Software

1 Answer

Student marksheet prepare wtih Ms Excel With following conditions

Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
for Ex:;
if(Or(m1<35,m2<3,m3<35,.....),TotalMark,Grade)) [enter]
here m1,m2,m3 ...are the cells denoting Marks, Totalmark is the cell Showing total marks and Grade is the grade applied for the condition. here also you can use one more if function to find the grade among A,B,C,D,E
First this function check whether any of the given marks are less than 35. if any of the marks is less than 35 it will get the answer TRUE for the OR Function and you will get the Totalmark Cell VAlue, else it will go to Grade Clause.

Dec 06, 2008 | Business & Productivity Software

1 Answer

Percentages in Excel

No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
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!

Aug 08, 2008 | Microsoft Excel for PC

2 Answers


how to do substract in exccel

Oct 08, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

194 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers


Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides