If Column X Is Less Then .. Increase By % Percentage

Oct 6, 2006

I 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?

View 3 Replies


ADVERTISEMENT

Increase In Value Due To Percentage

Sep 5, 2013

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

View 3 Replies View Related

How To Know Percentage Of Drop Or Increase

Mar 11, 2012

From below data I want a formula to know how many pecentage it dropped and how many percentage it was increased.

ABPercentage431112222207106141135447

View 1 Replies View Related

Percentage Increase In A Period

May 30, 2008

I'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).

View 9 Replies View Related

Average Percentage Increase

Jul 15, 2006

I 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?

View 2 Replies View Related

Increase Values By X Percentage

Jan 16, 2008

How 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 View Related

Percentage Increase Calculation With Time?

May 26, 2014

I 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%

View 6 Replies View Related

Calculating Amount Of Increase To Hit Percentage

Dec 9, 2011

I 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).

View 3 Replies View Related

Percentage Increase Or Decrease From Cell

May 2, 2012

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

View 7 Replies View Related

Formulas To Calculate Rent Increase Percentage

Aug 6, 2014

I 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 Related

Find Percentage Increase / Decrease Between 2 Numbers

Mar 4, 2014

I 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

View 2 Replies View Related

Automatically Increase Numbers At Interval By Percentage

Apr 21, 2008

how 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?

View 6 Replies View Related

How To Calculate Percentage Rate Increase With Annual Summary

Jun 6, 2014

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

View 2 Replies View Related

Excel Formula To Show Percentage Increase Of A Figure

Jan 24, 2013

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

View 6 Replies View Related

Increase That Amount By A Percentage Identified In Another Cell And Display The Value Only Without Any Formalas In A New Cell

Jan 19, 2009

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

View 8 Replies View Related

IF Function Formula Logic: For Every Increase Of Of Mhz, Give 25.00 Per 100 Increase

Nov 2, 2006

I 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 Related

How To Increase Column When Using A Row

Apr 10, 2014

Having an issue with copying down.

Workbook 1 has data vertical

Workbook 2 has data horizontal

I need the formula in Workbook 1 to pull from the respective date in workbook 2, or just a simple formula increasing the column by 1 for each row.My issue is that when i copy down, the column never increases, it stays on the same one.Example is attached.

View 5 Replies View Related

Formula To Increase Row Number By One (1) In Each Column?

Jun 12, 2013

writing a formula for the situation below,

In column "A1" i have the formula =C8. I now need to copy this formula across to column "B1" to get =C9 and also copy it across to column "C1" to read =C10.

So the row number should be increasing by 1 and the column remanin constant.

View 3 Replies View Related

Increase All Formulas Row/Column References

Jun 5, 2008

I need a script that will look for all the formulas in a sheet and increase them by a digit.

Lets say one that particular formula is =(A1-A2)/A2*100

I need the macro to change this to =(B1-B2)/B2*100

I have already programmed in a Find/Replace command, but realised that this would only work one time only. I need generic code that will bump them up each time rather than having to hard code the Find/Replace command for every single cell in the book.

View 5 Replies View Related

Conditional Format To Mark Increase From Previous Column

Sep 5, 2013

I have a goal set for the year. With conditional formatting, each month will be set to either red or yellow based on where it stands in relation to the goal. I would also like to show an increase or decrease in productivity for each month. I tried to use conditional formatting with the formula:

=IF(C2=D2, "", IF(C2<D2,"↗","↘")).

The formula works on its own without the conditional formatting so I am not sure what I am doing wrong. I've attached a sample with all the conditional formatting and formulas in place.

View 5 Replies View Related

Excel 2010 :: Formulas Increase Incrementally Per Column

Jun 8, 2013

I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7). Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?

Excel 2010
A
B
C
D
E
F
G
H
I
J
K

1
ct
0
1
2
3
4
5
6
7
8
9

[Code] .........

Array FormulasCell
Formula

B8:B17
{=FREQUENCY(B3:HNR3,ball)}

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

Worksheet Defined NamesName
Refers To

'am (2)'!ball
='am (2)'!$A$8:$A$17

View 3 Replies View Related

4th Column In Listbox As Percentage

Jul 22, 2014

I have a four column listbox where 4th column is percentage. In my source worksheet cells are formatted as percentage but when this is displayed in list box it shows approximately 10 decimals or maybe even more. How can I change my code only to show two decimals in 4th column?

View 3 Replies View Related

Copy Percentage To New Column

Nov 9, 2009

i would like to copy my sheet 1 column K which has format cell in percentage and copy over to sheet 2 column K. But it will display decimal places rather then percentage. below code is i use to copy and paste special value. but its not workin.

View 5 Replies View Related

Column To Take Out Percentage Of Column A Up To Set Amount?

Nov 8, 2013

column to take out a percentage of column A up to a set amount. So B takes out 100% up to $40 then C takes out 100% up to $20 etc.

how I can get my spread sheet do accomplish this.

View 8 Replies View Related

Applying A Percentage To A Long Column

Jan 9, 2009

I have a long column of numbers that I want to apply a single percentage to all the numbers in each column. How do I do that?

View 3 Replies View Related

How To Add Percentage Column At The End Of Regular Columns

Feb 5, 2013

I want to track a friendly competition of squash games with a friend.

player1
player2
January

[Code].....

I have a simple column chart showing the progress of each month but I'd like a 13th pair of bars showing the percentage, with the percentage scale on the secondary axis. Do I have to choose the percentage cells as a separate series?

View 8 Replies View Related

Calculated Percentage Of Column Filled?

Jan 7, 2014

I would like to figure out a formula that will calculate what percentage of a column is filled based on the total number of rows.

For instance if I have Column K and that will have delayed savings by sales pursuit, I want to be able to calculate the percentage of what is being delayed from a total number of pursuits (basically the count of rows in column A). Ideally this would be a dynamic range (offset).

Ex. Say I have 25 rows in column A, but I only have 2 rows in column K filled. How can I calculate that there is a 8% (2/25) delay?

View 2 Replies View Related

Columns With Text To Column With Default Percentage

Jul 3, 2012

I have a spreadsheet that tracks in column D "completed" projects. I want column T to populated "100%" when column D has the text "completed" in the cell. What is the formula?

View 1 Replies View Related

Pivot Showing Percentage In Grand Total Grouped By First Column?

May 16, 2014

i'm trying to crack what should surely be a simple problem. Attached is my spreadsheet.

As you can see I have 3 columns of detail, with totals spread over a number of months.

I want to be able to display the percentage of the Resource total for each other grouping.

For example, in my spreadsheet you can see resource Mick Arber at the top. I want to be able to see each of his rows as a percentage of HIS total.

View 1 Replies View Related

Excel Average Dates - Calculate Percentage For Each Column Individually

Feb 11, 2014

I have an excel spread sheet with columns of dates I am trying to get an average formula that counts dates less than a year old as 1 and blank cells and dates greater than a year old as 0 and then gives me a percentage. For example I have a column with 10 dates all less than 1 year old I would get 100% but if I had a column with 8 dates less than a year old and 1 dates older than a year, and 1 blank cell, I would get 80%

Is this possible at all, or do I have to calculate the percentage for each column individually.

View 9 Replies View Related







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