Increase Values By X Percentage
Jan 16, 2008How do I change numerous numbers in several different columns by a constant amount? example reduce each number in each of these columns by 50%.
View 9 Replies
ADVERTISEMENT
Increase In Value Due To Percentage
Sep 5, 2013I have a sheet comprising of 4 columns, laid out like the below ;
A4 = Equipment
C4 = Cost
E4 = Revenue
G4 = Gross Profit
I require to enter a percentage into the gross profit column, and for this to interact with the cost column, then for the revenue column to return the total of the cost including the profit.
How To Know Percentage Of Drop Or Increase
Mar 11, 2012From below data I want a formula to know how many pecentage it dropped and how many percentage it was increased.
ABPercentage431112222207106141135447
Percentage Increase In A Period
May 30, 2008I'm doing research with a professor at the University of Florida. This is my first time using Excel to any extent, so I need everything from the ground up!
I have the housing values for each of the 50 states from 1975 to 2006. I need to analyze each state individually to see if there were any points during that 26 year span when housing values increased by more than 20%. I need to know when this increase started and when values peaked and began to fall. I could do this manually, but I'm assuming that would take a while.
Is there a simple way to do this in excel? A macro, or a UDF (I have no clue about either of them by the way).
The 50 states are listed in a column and the rows next to each state having housing values for the 26 years. ( I don't know if that is relevant).
Average Percentage Increase
Jul 15, 2006I just can't figure out how to create a formula to figure out the average Percentage increase over two figures.
For example:
Amount 1 Amount 2
$17,330,000$20,150,000
Would I use the average function?
If Column X Is Less Then .. Increase By % Percentage
Oct 6, 2006I need to do the following:
If column X is less then < £1000 will have a 15% increase, those less than < £1500 a 12 % increase and any figure greater than > £1500 a 10% increase.
I could easily do this using a case statment using VBA, but im not allowed, any idea of a formulae that would do it?
Percentage Increase Calculation With Time?
May 26, 2014I want to calculate % increase with time related fields
Field A1 = 01:53 (formatted custom as mm:ss) happy to format some other way
Field A2 = 02:08 as above
I want to know the % increase. The correct answer is 13.27% , as 01:53 = 113 seconds and 02:08 is 128 seconds and 128/113 = 1.1327 so 13.27%
Calculating Amount Of Increase To Hit Percentage
Dec 9, 2011I need a formula that will tell me how many minutes/hours are needed to hit a certain percentage.
For example, I need to do 60% of my time doing one thing (Team), and 40% of my time doing another (Individual). So, I need to know, if I've spent 5.5 hours doing Team, and 4 hours doing Individual, I need to know that I need to do .5 hours to hit the correct split.
I can't figure out what formula to use that will increase the current total to best figure out how many minutes I'll need to do either Team or Individual to hit the 60/40 split. It doesn't need to actually tell me 15 minutes, etc, but .25 would be fine (everything is done in .25 increments).
Percentage Increase Or Decrease From Cell
May 2, 2012I need a formula that can work out a percentage increase or decrease from cell J2 to L2.
J2 is the current data with L2 being the previous data - so the formula would compare J2 with L2 and tell me if there is an increase or decrease shown as a percentage.
The figures fluctuate from month to month so they could be either an increase or decrease. There are over 300 entries so I can't go through each one adjusting the formula accordingly - this is why I need the formula to do the working out if it is up or down.
Formulas To Calculate Rent Increase Percentage
Aug 6, 2014I am trying to do a spreadsheet that calculates the monthly rent from 9/1/14 through 1/1/15, then rent gets reduced from 2/15/14 through 1/1/16, then after that there will be an increase of 3% per year for each year until 8/2019.
View 1 Replies View RelatedFind Percentage Increase / Decrease Between 2 Numbers
Mar 4, 2014I have totals in d18 and e18 and need to find the percentage increase or decrease between the 2. E18 is last year's value and D18 is this year's value. Which formula will give me what I am looking for:
(D18-E18)/D18 or (D18-E18)/E18
Automatically Increase Numbers At Interval By Percentage
Apr 21, 2008how to make a number automatically increase by a percentage at a certain interval.
For example, 1-12 need to be 3% of 100, so, 3. Then, from 13-24 need to be 3.5% of 100, and so on. Does anyone know how to do this?
How To Calculate Percentage Rate Increase With Annual Summary
Jun 6, 2014What I need is a worksheet which will generate fields from a set of variables (similar to a loan amortization schedule).
I don't know how to write the field code to include the annual percentage rate increase based on that additional input variable.
Input variables would be:
starting rate: (ex: 8¢/kilowatt hour)
starting date: (ex: July 2013)
average kw hours/month: (ex: 1062.5 kw hours)
annual rate increase: (ex: 3% *default 0%)
years to display: (ex: 25 years, *shown in months in fields below)
service months per year: (ex: 12 *default 12)
[code].....
So, data fields below the variables would be blank until these are entered.
Assume I would protect the sheet to avoid messing it up.
this would generate a chart showing rates over time from the fields below.
Also it would generate fields in a summary area to show the rate per year for future years.
Secondary, if there were a way to input actual usage and rates from specific months in the past, that would be useful but not part of this forecast model.
The goal of this model is to forecast electrical costs for residential power users compared to independent solar power generation to 25 years forward.
I want to make this because I am skeptical of the advertised savings that solar installers use to convince clients that their return on investment is so high. I believe their data to be greatly inflated projections.
Using this in comparison with other data such as inflation and wages will allow me to get a very good economic picture of the future of independent solar energy generation and its impact on the average home owner.
Excel Formula To Show Percentage Increase Of A Figure
Jan 24, 2013Looking for a formula to show percentage increase of a figure.
Cell A1 is £45,000
Cell A2 is £51,000
Cell A3 ANSWER result shown as a percentage increase.
Increase That Amount By A Percentage Identified In Another Cell And Display The Value Only Without Any Formalas In A New Cell
Jan 19, 2009If a cell is not blank, then increase that amount by a percentage identified in another cell and display the value only without any formalas in a new cell. To this end I wrote this IF statement:
=IF(I2>0,CP9=(CA9*I2/100)+CA9,CP9="")
Observation: I see a FALSE in CS9 where this IF statement exists, however, CP9 does not display the required value.
IF Function Formula Logic: For Every Increase Of Of Mhz, Give 25.00 Per 100 Increase
Nov 2, 2006I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.
View 2 Replies View RelatedIncrease/decrease Values Individually?
Oct 13, 2008I have a single simple question, so let's get straight to the point: I have an A column with these values:
I:::I::::::A::::::I::::::B:::::....
I==================== ....
I 1 I____40____I_________ ....
I 2 I____50____I_________.....
I 3 I____30____I_________.....
And I need each of these values increased/decreased by a constant number.
So far, I only found formulas where all cells are, say, added into a single result, as you can see here:.....
Coloring Percentage Values
Oct 7, 2008I need to coloring percentage values in excel 2000. What I would like to do is have percentages greater than zero shown in green, while negative values are red, and zero values are black. I currently have the custom formatting so negative values are red and all others are black, but I cant' seem to find a way to change it so greater than zero numbers are green and zeros are black. All I can do is chang positive and zero at the same time. Here is what I currently have:
View 3 Replies View RelatedPercentage Difference Between Two Values
Sep 15, 2009I am trying to create a formula that can work out the % difference between two values. The formula I am using is:
=(B1-A1)/ABS(A1)
So, where
A1=1, B1=2, = 100%
A1=-1, B1=2, = 300%
This seems to work perfectly, apart from where there are zero numbers involved. The answers I want to have are as follows:
A1=0, B1=0, = 0%
A1=0, B1=-1, = -100%
A1=0, B1=1, = 100%
A1=-1, B1=0, = 100%
A1=1, B1=0, = -100%
Exclusion Of Values In SUM/Percentage
Jun 19, 2009I am trying to exclude a certain value from an array of numbers to get a percentage. I have data that populates on its own and in the same columns regularly. The data contains a country name in column A, a year in columnB and a value in column C. I am trying to exclude the value for the U.S. in the totals so that I can get a percentage of values outside of the U.S.
So that the sum of all of the rows less the value corresponding to the U.S., divided by the sum of all of the values.
The problem is that the location of the U.S. value and U.S. designation varies with different inputs (this cannot be helped), so the formula must be able to follow it.
I have been able to do this but not without a lot of extra cells and rows, and I would like to have a single formula.
Displaying Percentage Values Over 100%
Feb 4, 2008I'm trying to make my spreadsheet display over 100% while calculating a long column of entries. Each entry is showing percentage cost per hour of a benchmark of $65.00 per hour. When an entry for example is $51.10 the percentage displays 0.79%, but if the entry is for example $73.89 then the displayed value is 1.14%.
How do I make this display the percentage over the benchmark of 65 as 110, 115 or whatever it calculates out?
Changing Percentage Values Automatically
Dec 2, 2013I'm designing a spreadsheet currently. I want to input a number into cell A1 - for example 13. Now the number 13 has a percentage value of 67.3%. When I enter the value into A1 I want excel to automatically fill cell A5 with the percentage value of 67.3%.
I need to have the numbers from 1-20 all with varying percentage values.
1 = 100%
2 = 97.8%
3 = 94.3% etc..
So essentially I would like to enter 13 into cell A1 and for cell A5 to automatically fill in the value of 67.3%, if I was to change the value in A1 to 10 it would also automatically change the percentage from 67.3% to 74.7%..
Conditional Formatting For Percentage Values
Jan 26, 2014Using conditional formatting to make all the cells that contain numbers and are formatted to percentage format make display in red color? let's say I want to set this conditional formatting rule initially after just opening the excel book and afterwards when I type in values/text etc. into the cells I want the cells where I have input numbers and chose the percentage format to come out in red color? and all the rest stay in black color?
View 6 Replies View RelatedDeleting Rows With Non-percentage Values
Jun 9, 2009What I would like to do is to delete the rows in the attached Excel file highlighted in yellow (whole numbers) and to keep the rows with percentage values. Ideally I would like to have only the rows with the string "Group:" remaining along with the rows that have percentage values in them.
What I'm going to be doing is then transferring these groupings of data to another excel sheet in order to create a time series of performance by "team leads". If anybody would be willing to help me out with the first part of this I would really appreciate it. I have some idea of how to go about it using conditional logic, but I'm just not comfortable enough in VBA to do this efficiently. It would probably take me hours just to get a simple version working....
Finding Percentage Of A Range Of Values
Feb 13, 2009I have a little table:
Columns A:B (separated by commas)
Row 1- Year One, 20
Row 2- Year One, 20
Row 3- Year One, 10
Row 4- Year One, 30
Row 5- Year One, 20
Row 6- Year One, 20
Row 7- Year Two, 10
Row 8- Year Two, 20
Row 9- Year Two, 20
Row 10- Year Two, 10
Row 11- Year Two, 20
Row 12- Year Two, 40
In the adjacent cells in columns C (C1:C12) I need a formula that would turn the value into a percentage of the total of the values for that year (e.g. in C1: 20 is 16.7% of 120, so the value displayed would be 16.7% (or 0.167)).
One Value With Multiple Values Within - Need To Calculate As Percentage
Jan 16, 2014I have a list of group ID codes, which contain 1 or more product codes within them.
Some product codes contain an "alternative" value (the actual value is irrelevant) and others do not. See example below
Group ID
Product Code
Alternative
56381
240027
160380
[Code] .....
Ultimately what I need to achieve is a percentage of how many product codes, within each group ID, contain an alternative.
So for the example above, group ID 56381 would have 50% codes with alternatives.
By counting the occurrences of a group ID and whether 1 particular code has an alternative I have calculated individual percentages against the size of the group e.g. product code 240027 (given a value of 1) divided by the total number of codes in the group (4), returns 0.25. Obviously doing this across the whole group would give my result (0.5 or 50%)
However some groups contain over 100 codes and the spreadsheet is 40K rows!
Add 2 Cells Show As Percentage Of 3rd Cell But Still Allow For 0 Values
May 23, 2013I am trying to add 2 cell values together then show the total as a % of a value in a 3rd cell, however I also need it to allow for 0 values in the chosen cells without displaying an error message or it messes up the average formula elsewhere on the sheet?
View 2 Replies View RelatedAdjusting Percentage Values On Cell Change
Jan 8, 2009Good afternoon Gentlemen, I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
Now... when I change one of the values I would like the others to even up, i.e. in the last example if I change a 20% to 50% I would like the others to change to 10%... any ideas?
Take Cell Values From Six Worksheets And Adds Them Up As A Percentage
Jan 27, 2010How would I write a formula that takes cell values from six worksheets and adds them up as a percentage (quarterly updates)? I realize this is wrong, but here's what I'd tried (for three sheets).
=+SUM(IF(EVH!F7="Y",25,0)+IF(FUN!F7="Y",25,0)+IF(HES!F7="Y",25,0))/3
Formula To Determine Required Values To Achieve Target Percentage?
Aug 24, 2014Data is;
83300 - hypothetical number of times I have fired my gun at target.
43209 - hypothetical number of times I have scored bullseye.
So, my bullseye percentage = 43209/83300, or ~51.87%.
Need formula to determine how many more consecutive bullseyes I need to shoot, in order to achieve 70% ratio.
Since each shot from now on will be a bullseye, both values (hits & shots) will increment together.