Question about Microsoft OFFICE 2003 BASIC OEM ENGLISH MS (S550039701)

# Its for calculating the stak ranking

If the total percentage of x is between 85%-100% then the value should be 5, if the total percentage of x is between 75%-85% then the value should be 4, same for 3,2 & 1.If someone can help I apprecioate it.

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

=IF(D1>=85,"5",IF(AND(D1>=75,D1=65,D1=55,D1=45,D1
You should use above formula. It will be useful for you.

Posted on Oct 14, 2010

Hi,
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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > 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

https://exceljet.net/formula/get-percentage-of-total
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 | Computers & Internet

### How do you figure out the percentage of a budget

The percentage is simply 100 x (things you are interested in / total).
So for example the percentage of foodstuffs which go, with the other things to make up the household expenditure (budget) is
100 x (amount spent on food) / (total household spend), or
100 x (food budget) / (total household budget)

5.May.2014

May 05, 2014 | Office Equipment & Supplies

### During 2006, a swimming lesson at a particular school lasted 45 minutes, In 2007 the time will be 50 minutes, Find the increase in the lesson time from 2006 to 2007 as a percentage of the lesson time

Percent change =100%*(new value-old value)/(old value)
If result is positive, it is an increase. If the value is negative it is a decrease.
100%*(50-45)45=100% *(5/45) =11.11 %

Mar 30, 2014 | Casio ClassPad 300 Calculator

### How to calculate percentage

Divide 20,000 by 10,000, subtract 1, then multiply by 100 to get 100%.

Feb 04, 2014 | Office Equipment & Supplies

### Calculate percentage increase

Percentage change (increase or decrease)=(New value -Old value)/(Old value)*100%
If result is positive it is an increase. If result is negative it is decrease
% increase=28.298%=28.30%
Compare the definition above with the inflation measure and decide if they are the same.

Dec 30, 2013 | Office Equipment & Supplies

### Calculate percentage increase

Percentage change = (new value -old value)/old value * 100%
If result is positive it is an increase. If it is negative it is a decrease
Here
%increase=(500-5)/5*100=9900 %

Dec 07, 2013 | Office Equipment & Supplies

### What do you have to do to become a Wiz in FixYa? I am new and have put in 41 solutions but am still at Master status. When will I be a Wiz and how long until I am a premium expert?

Rank Average Rating Minimum Number of
Solutions Posted Guru 85% or higher, 5 votes minimum. 50 Wiz 80% or higher, 5 votes minimum. 30 Master No Ratings Required 10 Guide No Ratings Required 5 Apprentice No Ratings Required Rank Average Rating Minimum Number of
Solutions Posted Guru 85% or higher, 5 votes minimum. 50 Wiz 80% or higher, 5 votes minimum. 30 Master No Ratings Required 10 Guide No Ratings Required 5 Apprentice No Ratings Required You need to visit the Expert FAQ's section to get answers to this, link is http://www.fixya.com/FAQexp.aspx

but here is an extract:

Ranks are calculated by dividing the total value of the ratings cast on an Expert's Solutions by the Expert's number of rated Solutions. Unrated Solutions, Premium ratings, and Live Chat ratings are not factored into Experts' averages.

Rank Average Rating Minimum Number of
Solutions Posted Guru 85% or higher, 5 votes minimum. 50 Wiz 80% or higher, 5 votes minimum. 30 Master No Ratings Required 10 Guide No Ratings Required 5 Apprentice No Ratings Required
Wizz needs 80% or higher ranking, 5 votes minumum and 30 solutions minimum.

The help screens are good so just have a look around and you'll find out lots.
Rank Average Rating Minimum Number of
Solutions Posted Guru 85% or higher, 5 votes minimum. 50 Wiz 80% or higher, 5 votes minimum. 30 Master No Ratings Required 10 Guide No Ratings Required 5 Apprentice No Ratings Required

Rank Average Rating Minimum Number of
Solutions Posted Guru 85% or higher, 5 votes minimum. 50 Wiz 80% or higher, 5 votes minimum. 30 Master No Ratings Required 10 Guide No Ratings Required 5 Apprentice No Ratings Required

Aug 22, 2011 | FixYa Service

### How do I find what the percentage is . . . the amount is 4,117,484 out of a total amount of 163,715,657. I usually divide the amount by the total but when I use a calculator to check (by multiplication)...

100*4117484/163715657 gives me about 2.5%. Since you didn't specify the calculator your're using, I can't give you the exact keystroke sequence, but on a typical algebraic calculator it would be something like 1 0 0 * 4 1 1 7 4 8 4 / 1 6 3 7 1 5 6 5 7 =

On an RPN or RPL calculator, it would be
1 0 0 ENTER 4 1 1 7 4 8 4 * 1 6 3 7 1 5 6 5 7 /

Mar 04, 2011 | Office Equipment & Supplies

### How to calcolate %

Inputting a value and pressing SHIFT [%] converts the input value to a percent. For example:
2 SHIFT [%] = produces .02

To determine 20% of 150:
150 * 20 SHIFT [%] = produces 30

To calculate what percentage of 880 is 660:
660 / 880 SHIFT [%] = produces 75

To increase 2500 by 15%:
2500 + 2500*15 SHIFT [%] = or
2500 * (1+15 SHIFT [%] ) = produces 2875

To discount 3500 by 25%:
3500 - 3500 * SHIFT [%] = or
3500 * (1-15 SHIFT [%]) = produces 2625

To calculate the percentage change from 40 to 46:
(46 - 40) / 40 SHIFT [%] produces 15

Sep 11, 2010 | Casio FX-115ES Scientific Calculator

### 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.

Feb 19, 2009 | Microsoft Computers & Internet

## Open Questions:

#### Related Topics:

54 people viewed this question

Level 3 Expert

Level 3 Expert