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
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
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
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
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.
View 9 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
Jul 3, 2014
I have percentages in Col C. I would like to count the number, excluding zero percentages
View 3 Replies
View Related
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
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
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
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
