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


ADVERTISEMENT

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

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

Formula - Trying To Average A Column That Has Percentages

Jan 16, 2009

I have been working on this for days and cannot come up with a answer to this. I am trying to average a column that has percentages. some of the cells have o's in them and the numbers that I am trying to average is a weekly number. So I am trying to average every 7 days percentage. Is there a way to do this? I have looked thru the forum and all over the web and can't come up with an answer. I have excel 2003. Do I have to write a macro for this or can I just do a formula? If so how do I do it?

View 9 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

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

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.

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

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







Copyrights 2005-15 www.BigResource.com, All rights reserved