Working With Percentages

Aug 20, 2008

I have a column of data with students marks ranging from zero to 78(S17:S74). I need to work out the mean score of the bottom 20% of all the scores achieved - Is this possible. I'm no expert so please keep it as simple as possible! I'm working with Windows XP and Excel 2002.

ADVERTISEMENT

Working With Percentages Over Many Cells

May 10, 2007

I have 100's of cells with various formulas similar to this: =U7*9.57. U7 Being the cell with the number of hours worked and 9.57 being the hourly rate. Fairly simple so far. Now there has been a 5% pay rise so unless i get another formula to add 5% on to all these cells i will have to manualy change each hourly pay to the correct value, something i dont want to do. So my question is can i do something like =U7*9.57 then another formula to add 5% on to the 9.57, then i can copy the formula down all the other cells?????

View 3 Replies View Related

Scale Of Percentages Using IF Statements And Percentages?

Jun 27, 2014

I need a formula to create the following:

In Cell F5 is 26, so the percentage should be 101% (100+1). How can I modify the below to add 1% when the number goes over 100%?

Do I have to create two columns? one for the below and one if the F6 is over 100%?

IF(F6="N/A","N/A",IF(F6>=25,1,IF(F6>=19,0.8,IF(F6>=13,0.6,IF(F6>=7,0.4,IF(F6>=1,0.2,IF(F6

View 5 Replies View Related

Top 10 Percentages

Jul 20, 2009

I am working with a list and would like to show the top 10 careers in %.

Out of 914 votes __ % are interested in Nursing, __ % are interested in ABC, ___ % DEF, etc.

View 2 Replies View Related

Look Up Using Percentages

Dec 4, 2009

i have a figure of 395.00 euros to start and need to calculat percentages when i enter a certain figure ...

View 8 Replies View Related

Calculating Percentages

Mar 10, 2009

I think a really easy no brianer, I need to find the difference in percentage terms of two values. I am using =(B2-A2)/ABS(A2)

where B2 = 24.09
and A2 = 21.08

View 2 Replies View Related

Annualised Percentages

Oct 15, 2009

I am monitoring the balance in my Allocated Pension fund, via the WWW.

In particular, I am recording the profits (disregarding costs, outflows, etc.) as ANNUALISED PERCENTAGES (a new line, for each week).

My formula is:

=(accumulated profits/principal)*(365/elapsed days)

Questions:
Will my formula remain valid, when ďelapsed daysĒ exceed 365?

If not, is there a FUNCTION that can handle my problem. And

What would the functionís ARGUMENTS be?

View 3 Replies View Related

Calculating Percentages ...

Jul 26, 2006

I'm sure this will be an easy calculation for most of you...........

If I have two numbers, ie. 390 and 217, how can I calculate the difference
between the two figures as a percentage? (These two figures represent sales
in two months and I need to know the difference in percentage terms).

View 10 Replies View Related

Highlight Only Percentages

Mar 14, 2012

I would like a way to use conditional formatting to highlight percentages that are over 50%. The problem is that I have other numbers in the same column that are not percentages but I would like to ignore them for highlighting purposes? Can this be done without sorting the columns?

eg.

345- ignore
Ken- ignore
2500- ignore
45.6%- do not highlight
65- ignore
92%- highlight

View 5 Replies View Related

How To Calculate Percentages

Nov 5, 2013

=IF(A2-B2,(B2/A2))

The simple formula above calculates percentage which basically in this example, 159-90 divded 159% which equals 56.60%. What i need the formula to recognize is if both the entries are 159 which should show 100%. Its to show error rates by the way. Percentage wise.

View 3 Replies View Related

Formula - Percentages

Jul 2, 2007

Am trying to do a formula to work out a percentage of one figure from another, cannot for the life of me think it through properly!

So in

Cell J73 I have the net income and in cells J75 +J77 I have the total outgoings.

I want a formula that works out the percentage outgoings, so if someone is earning £100 and they have £20 outgoings, that is 20% of their earnings.

View 9 Replies View Related

Decimals To Percentages

Jan 4, 2008

I am trying to combine to cells containing percentages, however when I do the percentages turn into decimals. I have tried using the text funtion, but that just returns the full number 1, no decimals or percentages.

View 9 Replies View Related

Calculating Percentages In XL 03

Mar 2, 2008

I work at a library and have been asked for help by the Asst. Director. The problem is, I have next to no Excel experience, just what I've been reading in the Help files and Online.

We are using Excel 2003 and running XP. Here is his predicament: he has an excel document that lists the books we have ordered from a publisher. Column I has the MSRP for the book and Column J has the discounted price for the book. We are trying to get Column L to show the percentage of the discount that we received. This is what i've come up with:

example for line 255 typed in as formula for L: =1-7.95/14.98

It comes out correct when I type in the formula as I show above, but when I try typing in the formula (as it should look:=1-J255/I255) , i get an error message: #VALUE! ...

View 9 Replies View Related

Applying Percentages

Jun 17, 2008

I have a table of data with names across the top and number of weeks down the left. The table lists amounts of money those names earned during the respective weeks. It looks something like this:

Mike Dan Bill Carl
400 500 600 700
800 900 1000 800
700 600 500 400

In a seperate worksheet within the same workbook, I have 3 columns of data. The first column is a name. The second column is a criteria. In the third column, I am trying to look up the value of 8 specified weeks of earnings of the name I put in column 1 and multiply those earnings by a percentage based on the criteria in column 2. Then sum the products.

I have a table of the 8 percentages I am trying to apply. There are 7 different percentage applications.

So if I am looking up Mike's earnings during those 8 specified weeks and the criteria in column 2 is "B", then I want to apply the appropriate column of percentages to those 8 looked up earnings, Multply them and then Add them.

Up until now, I have been trying to use some hybrid of HLOOKUP, SUMPRODUCT, and IF.

View 9 Replies View Related

Remove The Percentages

Sep 16, 2009

I have data that I import from another source into excel and it pulls over like this

3866.00%
435.00%
125.00%
1254.00%

I want to remove the % since these aren't actually percentages, the report we pull from has them listed incorrectly and cannot be changed since it is software driven, not excel driven. The problem is simply remove the % changes the number to 38.66 instead of leaving it at 3866.

View 9 Replies View Related

Average Percentages ...

Jun 24, 2006

I have a row of formulas that calculates information into a percentage. As you input info, a percentage is created in the cell. Those cells that do not yet have information entered still show " DIV/0" or something like that.

I need a formula that will average all the percentages, but the problem is, it's trying to also average the formulas with the percentages, so I currently get an error.

View 9 Replies View Related

Percentages In Cells

Jun 25, 2006

I am using an excel loan amortization schedule but I need to add another cell to calculate percentages. how do I do this? I need to know the command.

View 2 Replies View Related

Adding Tiered Percentages?

Apr 4, 2014

Input cell: a number from 1 - 100

Output cell:

If input is 1, output is 5.5%
add 0.5% until 10.
add 1% from 11 - 20
add 1.5% from 21-30
add 2% from 31-40

keep adding 0.5% every 10, until 100
100 = 280%

View 1 Replies View Related

Show Values In Percentages

Aug 12, 2014

I want to show values entered with percentage sign.(%) Right now, if i enter any value say,10 in a cell having percentage format, shows 1000%. For that, I don't want to enter 0.1. I just want to enter any value and see it with percentage symbol.

View 4 Replies View Related

Round Percentages (Up And Down) By Multiples Of 5%

Sep 29, 2009

How do I round percentages, both up and down, to the nearest 5%?

Ex. 82% to 80% as well as 84% to 85%

View 4 Replies View Related

Convert Whole Numbers To Percentages In Vba

Jun 18, 2014

I have a sheet that shows me in column I, J , K whole numbers eg. 25 , 50 , 25

I would like to format this to percentages eg. 25%, 50%, 25%

The number of rows can grow as well.

View 6 Replies View Related

Scroll Bar To Change Percentages

Nov 23, 2008

I'm trying to get a scroll bar to change a percentage value. My percents are to the hundredth. I understand how to adjust the properties to get it to use whole numbers... but i am trying to adjust my smallchange by .01% and large change by .1%
is this possible? or is there a workaround for it? i've only ever used scroll bars for whole numbers.

View 2 Replies View Related

How To Assign Monetary Value To Percentages?

Jan 6, 2010

I'm brand new to this forum, so please forgive me in advance. I am hoping someone might be able to point me in the right direction. I got a request from my boss and it's something I've never done in Excel and far more advanced than anything I've tried to do.

In my spreadsheet, Columns B-BD are server names, and Rows 2-13 are program names. Inside the corresponding cells all have to display as percentages, and we are trying to display what percentage of each server is being used by each program. In Row 14, each column must total to be 100%. That part is easy, I already have that all setup.

However, the next step requires that each server is assigned a monetary value - one of two monetary values for Virtual or Physical server. Then, somehow I need Excel to calculate the monetary value for each percentage.

For example: if Column B is Virtual, and Row 14 totals up to equal 100%, it also equals $1,000. Say Cell B4 is equal to 50% and B5 is equal to 50%, each cell is also equal to $500. Easy enough in theory, but how should I execute this so that these cells stay in % format, but Column BE titled "Total Cost" displays the monetary value for each Program (row)?

I'm pretty sure there will be some kind of formula so I guess that's what I'm asking... how to calculate it?

I'll attach a screen shot to show you the gist of how it looks so far ...

View 14 Replies View Related

Percentages - Calculate Original Value

Apr 12, 2012

I have two issues:

1, How do I calculate the original value of something if it has dropped say 9.3%
Ex Stock value 5.56 down 7.4%. How do I calculate its original value.

2, I have copied some numerical data from a website, on one computer when I drop that data into an excel sheet it falls into separate cells allowing me to manipulate it, on another computer I drop it into an excel spreadsheet and all the data goes into one cell not allowing me to manipulate it.

I was wondering is there a setting on one excel spreadsheet that I am inadvertantly not using on the other.

View 4 Replies View Related

Percentages With Negative Goals?

Feb 4, 2014

I need to get a percentage, whether it is negative or positive or 100% of goal for column E (for ie. Chardonnay would be +168%; CS would be -61%). Everything I have tried from previous posts just brings me to a % sign in column E with no number.

Shipment Goals thru January
%
Actual Shipments YTD
(+/-) Percent of Goal(Col E)
Cases Needed to Order

Chardonnay
0
100%
168

[code]....

View 3 Replies View Related

Count Ignoring Zero Percentages

Jul 3, 2014

I have percentages in Col C. I would like to count the number, excluding zero percentages

View 3 Replies View Related

Percentages Shown At The Top Of Columns

Apr 5, 2007

Columns O,P and Q should show a "Y" if Column N has the percentage (the percentages shown at the top of those three columns) over the value in column D. I hope this makes sense!

******** ******************** ************************************************************************>Microsoft Excel - Team Lead Incentive.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF3H3N3F4H4N4=
CDEFGHIJKLMNOPQ1***WF*Team*Lead*Incentive****As*of*4/5/07***(15%)(20%)(25%)2TeamBase*Team*****Hours******Wk*1Wk1*%Wk*2Wk2*%Wk*3Wk3*%Wk*4Wk4*%*Total$75*$100*$125*32600.25*592.00-1.37%623.753.92%*****2.54%***43388.00*467.5020.49%527.5035.95%*****56.44%***WF*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies View Related

Pivot Table - Percentages

Oct 14, 2008

I am trying despeartely to finish this out. Here is the deal. I created a pivot table (see attached). The issue is that I need the numbers in the red boxes to be a percentage of the total number below - so the 2 should be a percentage of the 9 (22%) and the 3 should be 100% and the 7 should be 78%. I cannot seem to get this to work. Also, there are multiple rescue groups that need this and each needs to be the % of its own total number of animals.

View 9 Replies View Related

Chart Or Graph Percentages

Sep 11, 2007

I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc....

View 3 Replies View Related

Pivot Table Percentages

Jan 5, 2008

I have chunks of raw data held in my spreadsheet and i am using pivot table to give me the final results based in the criteria selected, I now need to add another column to my pivot table to give me a percentage value from 2 values within the table- is this possible ?

(is there a way of adding a column into the table and insert a function to carry out the calculation?)

- I am looking to do it this way so that instant charts/reports can be easily made......

View 3 Replies View Related

How To Show Percentages Next To Numbers In Charts

Dec 2, 2013

So I have a bar chart with numbers as its data labels...so each bar is divided into 4 colors equaling to 100% ...how can i show percentages next to numbers in the chart...so for example if a bar equals to 200 and each color is lets say 20, 60, 40, 80 ...i would like to show these numbers as well as percentages..i know we can do this manually by inserting a text box but the percentages might change quite often and i dont want to go through the hassle of calculating and changing them each time.

View 1 Replies View Related

How To Transfer Names Instead Of The Percentages To Another Cell

Mar 29, 2014

We created the following spreadsheet at work:

Col A. Col B. Col. C. Col D
Names. Week 1. Week 2. Week 3

Angela. 1.171875
Mara. 1.127214
Linda. 2.552553
Margaret. -1.4157
Lisa 0.12432
Joy 1.109654

Winner. 2.552553
2nd place. 1.171875
3rd place. 1.127214

This is a chart recording the percentage of weight everyone loses each week. We input the weight and it calculates the percentage lost. My question is that I would like the names of the winner, 2nd place and 3rd place to transfer down to the bottom not the number. I was told its not possible.

View 9 Replies View Related

Split Percentages Into Groups Of 10 For 5 Segments

Jul 11, 2014

I have a percentage based input whose values can change, example:

Input matrix.png

I would then like this translated into a matrix that can adjust depending on the segment % input; like so:

Matrix.png

View 9 Replies View Related

Formula For Stats Table In Percentages?

Aug 25, 2014

I use a workbook that records data centered around course referrals.

The workbook also has a stats page. It records Instructor stats but needs to be in the form mostly of percentages.

In Column D within the page Stats I need the cells to show the total number of "YES" that each Instructor has achieved from their number of pupils in the Sheet Data.

Column E and F in Stats need to show the percentage of Yes and No of each Instructor from Column D in the Sheet Data.

Column G In Stats needs to show the number in total of Referrals made by Indivisual Instructors taken from Sheet Data.

Columns H,I and J in Stats need to show the percentage of referrals to OBT,Kaya and HWal made by the Individual Instructors taken from Sheet Data.

Finally in Stats, Columns K,L and M need to show the percentages for each Instructor of their Leave Reason again Taken from Sheet Data.

Usually there are several hundred entries and at the moment I do this manually with a calculator.

View 2 Replies View Related

Percentages Between Positive And Negative Numbers?

Feb 27, 2014

I have to calculate percentages, lots of them,, have 4 scenarios

1.- positive / positive

2.- positive / negative

3.- negative / positive

4.- negative / negative

I wish to find a formula that covers all scenarios, have thousands of data to calculate

View 2 Replies View Related

Counting And Percentages In Multiple Sheets

Jan 22, 2008

i have 4 worksheets with various names. i have an 5th worksheet with a named list (TabNames) of the 4 worksheet names

each of the 4 worksheets have cells with percentages in them.

i would like to check a cell from each sheet and see if the percentage is equal to or above a certain %, for example anything equal to or above 90%. then return the number of cells that meets or exceeds that 90% criteria.

so for example

sheet1 sheet2 sheet3 sheet4
A
1 80% 91% 76% 82%
2 80% 95% 92% 43%

so checking cell A1 in list TabNames would return 1, and checking cellA2 would return 2.

View 14 Replies View Related

Data, Performing Functions, And Percentages?

Mar 13, 2009

I have a very large grid of data, about 400Rx200C, which contains a lot of blank fields. All of this data is currently in values from 0-100 representing percentages, but not formatted as such. I need to make all of these values into Excel Percentages so naturally used Paste Special and Divide from a field with the value 100 in it and then simply format the cells as %.

However, this fills in all of the original empty cells with a 0.000% which I do not want, I need them to stay blank. And some of the cells that do have values also have 0.000% so I cannot just delete all of these values with a VBA script. I had been hoping the Skip Blanks option would do this, but it does not unfortunately.

View 3 Replies View Related

IF Statements, Percentages And Negative Values

Dec 15, 2009

I've hit a wall for the first time in my excel using career, Iíve searched the net high and low, asked the guys in my IT department and am so far stumped for a solution.

The problem is thus:

I have 3 columns, A, B and C.

Column A and B contain two numbers. Column A is "telephone calls offered" Column B is "Telephone calls Answered".

Column C is a calculation of the percentage of calls NOT answered. The formula I am using for this is =(A1-B1)/A1*1

This gives me a % as an answer.

Rows 1 to 66 are different time periods through out the day.

The problem is that for some fields, we donít receive any calls, at all. Or we receive a call in one time period, and it is answered in another.

so Lets say cell A1 is 0, and Cell B2 is 3. Or A2 is 0 and B2 is 0.

How is it possible to get excel to display 0% if, after the calculation the value is < or = to Zero?

I have tried the below "IF" function but it returns a #Value error

=IF((A1-B1)/A*1<=0,"0%",(D67-E67)/D67*1)

I now leave it to the capable hands of the anonymous internet gods of excel

View 2 Replies View Related

Code Makes Negative Percentages Red?

Aug 17, 2014

Following link explains how can format negative percentages.

[URL]....

Following code makes negative percentages red, positive percentages green.

[Code].....

I want to make; negative percentages red, positive percentages green, zero percentages blue, ---------->This is my question.

Attached File : Color Format.xlsm

View 3 Replies View Related

Total Of Percentages At Bottom Of Column

Dec 23, 2013

I've got a list of 20 percentages which can range from 100% to -100%, the total of the 20 percentages should always equals zero but I need excel to give me a total so I can find any calculation errors.

How can I get a total at the bottom of the column?

I've tried SUMIF/SUMIFS, the only way I can get that to work is if I have one cell for >0 and another for

View 5 Replies View Related

Calculating Percentages Of Multi-level BOM

Mar 13, 2014

So our company gets Material Statements which basically state what chemicals and how much of said chemicals go into producing X item.

I need to figure out the percentage of MASS for each chemical.

So data might look like this:

Total Weight of product: 500 grams or mg, etc.

Sub-Item - Contact - 450 g
Material - Copper - 425 g
Substance - Nickel - .05 g
Substance - Copper - 422 g
Substance - Lead - .02 g
Material - PVC Insul - 5 g
Substance - Polysomethings - .5 g
Substance - Red Dye - .4 g
Substance - Plastic - 4.1 g

So basically the sub-item line is 450/500
first material line is 425/450
substance is .05/425

the substance lines use vlookup to find the material line to divide by. formula i'm using is below:

=IF(B2="Sub-Item",I2/$M$2,IF(B2="Material",I2/VLOOKUP("Sub-Item",$B$2:I2,8,FALSE),IF(B2="Substance",I2/VLOOKUP("Material",$B$2:I2,8,FALSE),"n/A")))

B2 is either sub-item/material/substance
Col I is the mass of that line
M2 is the total weight of the item

Formula works until you get to the Polysomething lines in the above example data. instead of taking the material weight from PVC Insul, it takes it from Copper.

View 1 Replies View Related

ADVERTISEMENT