I am trying to calculate the percent increase in pricing.

Say I have $10.35 in cell A5 and 11.32 in cell A6. How can I calculate the

percent increase in cell A&. I know this has to be simple, but I seem to

have trouble getting it to work.

Thanks

Say I have $10.35 in cell A5 and 11.32 in cell A6. How can I calculate the

percent increase in cell A&. I know this has to be simple, but I seem to

have trouble getting it to work.

Thanks

- Percent increase calculations...
- Calculate Percent Increase Based On Matrix
- 6.70 X 10% Est. Percent Increase Or Decrease
- Formula to show percent increase/decrease
- Percent increase between 4 tests
- Percent increase in excel
- Calculating % increase/decrease (yr over yr)
- Calculate percent difference between fractional numbers
- Calculate percent of varying subtotals
- Formula To Calculate Percent Difference Between Last 2 Columns
- Calculating percent differences between columns or cells
- Calculating Percentage Increase Or Decrease
- Calculate Percent of Subtotal In Pivot Table
- Calculating Increase/Decrease % over prior year
- #DIV/0! with a percent
- Calculate percent from multiple criteria
- Calculations with increasing decimals shown
- Calculating Percentage increase or decrease
- Calculating with Percent Increase
- Calculating Percent complete
- Can not calculate daily percent change using excel functions
- Calculating Percent in Excel 2003
- Formula to calculate Increase/Decrease
- Calculating percent of one field over the sum of another

I have been working on this code for a little while (with lots of help form NBVC and Ska67can)

I was wondering if anyone could help me with the small amount of code needed to be able to automatically calculate the percentage needed from one year to the next. I simply need it to automatically create a third column each time the copy old data button is pressed, and I need the column to have the percent increase ((current year - past year)/current year). Hopefully you can understand what I am aiming for. I have the current code below, and I will attach a compressed and stripped version of my workbook.

Thanks a bunch to everyone in advance.

'Code created and edited by MBVC and Ska67Can Sub CopyPaste() Dim sht As Worksheet Dim LastRow As Long, LastCol As Long, LastRow2 As Long, LastCol2 As Long For Each sht In ActiveWorkbook.Sheets If sht.Name <> "Instructions" And sht.Name <> "SATcosts" Then LastRow = sht.Cells(65536, 4).End(xlUp).Row LastCol = sht.Cells(5, 256).End(xlToLeft).Column ' Check if Year has changed. If yes, proceed, else warning given. If sht.Cells(1, 2).Value <> Year(Now()) Then sht.Cells(4, LastCol + 1).Value = sht.Cells(1, 2).Value - 1 Range(sht.Cells(5, 4), sht.Cells(LastRow, 5)).Copy sht.Cells(5, LastCol + 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False sht.Cells(5, LastCol + 1).Value = 0 LastCol2 = sht.Cells(5, 256).End(xlToLeft).Column LastRow2 = sht.Cells(65536, LastCol2).End(xlUp).Row ' Add left/right borders With Range(sht.Cells(4, LastCol2 - 1), sht.Cells(LastRow2, LastCol2)).Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Range(sht.Cells(4, LastCol2 - 1), sht.Cells(LastRow2, LastCol2)).Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With Application.CutCopyMode = False ' Clear clipboard so big clipboard dialog will not appear when closing main workbook Else MsgBox "Year has not changed!" Exit For End If End If Next sht End Sub

I need to calculate the % of salary increase and bonus for staff based on a matrix.

1) The salary increase in based on the salary grid. Each staff is allocated a ratio as shown in cell H4 to H25. For example, for Abraham, he has obtained a rating of 2 and has a ratio of 78%. Looking at the salary grid, he should get a 13% salary increase.

2) The bonus is also based on a bonus grid. The bonus is based on the rating and job time.The date used for current date calculation is Jan 11 2008. For example, Abraham has a rating of 2 and a job time more than 18 months.Therefore, he should get a bonus of 24.99% based on the bonus grid.

I am trying to create a formula in salary increase% column (yellow) and the bonus % column (blue) to automatically update from the salary grid and bonus grid. The actual staff number is quite long and using a correct formula would ensure the data ia accurate based on the grid/matrix.

Appreciate any help.

Thanks.

Thanks in advance Stephen

******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutI2J2K2L2=

ABCDEFGHIJKL1 270658294 -0.071430.2615380.14634111.22%3 Sheet1

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

one from last year and one from this year?

Dec 07 data -37 Net (assume this is A1)

Dec 08 data -73 (assume this is B1)

% of inc/decrease = +97.3%

I used this formula: =(B1-A1)/ABS(A1)

Obviously this was not an increase but my percent is coming back as a postive. Does anyone have any insight into how to correct this problem? If there is a solution, can it be used universally because I am working on a huge file and need to use this formula for both the increase and decrease.

Thanks for any insight!

I am attaching part of my project.

thank you for your time percent Difference.xls

I just add the formulas for finding the percen difference for glucose and heart rate but I still need help with blood pressure

In Col A, I have the various "Systems" or areas. In Col B, I have "Pkg codes". In Col J, I have the service a la carte rate for each package offered in a particular area. What i would like to do is calculate the percent of each rate as compared to the subtotal of the package. I tried the calculation with a Pivot Table, but to no avail. I also did a work around in the data dump using the this SUBSTITUTE formula: =J17/VLOOKUP(SUBSTITUTE(A17," Total","")&" Total",$A$17:$J$28320,10,0) but it only worked on the first instance of finding the various Systems. As soon as a system repeated itself the formula went off. I need to calculation to continue repeating itself as it goes down the table. I have attached a sample of what I'm trying to do. ANY help would be greatly appreciated.

Thanks for the help!

Can anyone help?

I need a column with a formula which calculates the percentage increase or decrease from some 2006 figures to 2007 - but i cant see how to do it? Can anyone help?

An example would be:

2006 figure: 104

2007 figure: 201

I need to know the % increase or decrease in 2007 compared to 2006.

Thanks

It does not appear that subtotal percentages are possible in a pivot table using a calculated field. Is this true? (If so, what a glaring oversight by Microsoft). I've tried a variety of options, none of which produce the desired result, which is a subtotal percentage that adds to 100 percent and will recalculate as the table is changed. This seems to be a fairly common problem (without a solution!) judging from the posts I've seen

I have been able to successfully use Andrew Poulsom's great formula solution found elsewhere in this forum. It is a good solution for tables where all possible values for a subtotal will always be used, but it does not adjust/recalculate if the pivot table changes (in the example below, if one were to exclude TV, the subtotals in Chicago, for example, would not recalculate so that the market total for the remaining Internet and Radio would remain 100%)

Is there a way to do this with a calculated field, or a way that will adjust if a member of the subtotal is excluded?

Note in the image below, the pivot table "Amt" column comes from the Amout column in the spreadsheet, and the pivot table "Pct Mkt" is the sum of the "MktSubTotForm" column (uses Andrew's formula) in the spreadsheet side. This is the column I would like to replace with a calculated field or some other 'adjustable method' if there is one.

Thanks for looking,

Dale.

******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: 11.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutD2D3D4D5D6D7D8D9D10D11D12D13D14D15D16D17D18D19=

ABCDEFGHI1MarketMediumAmountÂ MktSubTotFormÂ Â Â DataÂ 2ChicagoInternet243.31Â MarketMediumAmtMktÂ Pct3ChicagoInternet24033.06Â ChicagoInternet26436.44ChicagoRadio223.03Â Â Radio24233.35ChicagoRadio22030.30Â Â TV22030.36ChicagoTV202.75Â ChicagoÂ TotalÂ 726100.07ChicagoTV20027.55Â LosÂ AngelesInternet38546.78LosÂ AngelesInternet354.24Â Â Radio27533.39LosÂ AngelesInternet35042.42Â Â TV16520.010LosÂ AngelesRadio253.03Â LosÂ AngelesÂ TotalÂ 825100.011LosÂ AngelesRadio25030.30Â NewÂ YorkInternet33050.012LosÂ AngelesTV151.82Â Â Radio22033.313LosÂ AngelesTV15018.18Â Â TV11016.714NewÂ YorkInternet304.55Â NewÂ YorkÂ TotalÂ 660100.015NewÂ YorkInternet30045.45Â GrandÂ TotalÂ 2211300.016NewÂ YorkRadio203.03Â Â Â Â Â 17NewÂ YorkRadio20030.30Â Â Â Â Â 18NewÂ YorkTV101.52Â Â Â Â Â 19NewÂ YorkTV10015.15Â Â Â Â Â Sheet1Â

[HtmlMaker light Ver1.11] 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.

I have used the following formula to calculate the % increase/decrease.

=IF(C4>0,+B4/C4-1,+B4/C4+1)

The formula works well, except if there is a loss in the current year and prior year.

I need to amend the formula by saying that if the value in column B (A)boutD4B5C5D5D6B7C7D7D8D9=

ABCD1Â Â Â Â 2Â Â Â AmendedÂ Formula3TotalÂ NetÂ ProfitNPÂ JanÂ 2008NPÂ JanÂ 2007%Â Increase/Â (Decrease)4Branch149,14527,02581.85%5Branch243,720(112,560)61.16%6Branch3(53,075)39,045-235.93%7Branch41,633,2651,169,11239.70%8Branch5(26,042)39,458-166.00%9Branch6(165,188)(92,712)278.17%Sheet1Â

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

I can't figure out what I'm doing wrong with a simple calculation. I have a spreadsheet that determines what percent increase over a previous quarter. The values can be negative or positive; however, I have one entry that I'm trying to divide zero by a number which results in the #DIV/0! error message. I rather have it say -1000% since that is the value I'm looking for. I now how to deal with a simple division by using an IF statement such as IF(B1,A1/B1,0), but this one is throwing me a curve. I would appreciate any help.

The attached spread sheet is a quarterly percent increase over the last one. In the example, N00377 represents a machine in cell D14 and D17, where cell D17 is the last quarter, and I'm comparing it to cell D14 which should show an increase or decrease in cell F.

******** ******************** ************************************************************************>Microsoft Excel - CEDR Top 10 History.xls___Running: xl2000 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutE14F14E15F15E16F16E17F17E18F18E19F19=

DEFG14N003778-75.0%*15N15951118.2%*16EDD2047808147.1%*17N003772-300.0%*18N15953-266.7%*19EDD20478080#DIV/0!*CAPA*

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

help from an Excel expert.

I have several worksheets setup for each account; these worksheets are

reports that are given to accounts to represent the status of our

service.

I also have 2 other worksheets (which are lists) to enter account data

regarding our service.

Sheet 1 contains 1 row of data per account.

Sheet 2 contains issues for accounts and may contain 1 to many rows

for an account.

Account worksheet: The Account Name, Account # are in cells a1 and

a2, respectively. In column C, rows 10 thru 15, I need to calculate

the percent which must be a result of 100 divided by total issues

(count) for the account (entered on sheet1 column C) * the number of

specific issues (count) for that category (entered on sheet 2, column

F) for each item in b10 thru b15. The following is an example of what

I need to achieve for an account that has a total count of 5 issues.

Issue_1 is listed once, Issue_2 is listed 3 times and Issue_4 is

listed once.

Column B ColumnC

Issue_1 20%

Issue_2 60%

Issue_3 0%

Issue_4 20%

Sheet 1 contains 1 row for each account and the account # is in column

B and the count of all issues for the account is in column C.

Sheet 2 may contain 1 to many rows for an account. The account # is in

column B. Column C stores an issue, which is the reason for 1 to many

rows. The issues that may be entered are 1, 2, 3, and 4; it is

possible for any issue to be repeated in another row.

Is it possible to enter a formula to achieve the results for Issues?

--

TIA

Jan

Thanks for your help, i have been stumped all day!

Can anyone help?

I need a column with a formula which calculates the percentage increase or decrease from some 2006 figures to 2007 - but i cant see how to do it? Can anyone help? An example is posted below:

Attendees Attendees

Mar 06 - Dec 06 Jan 06 - Jun 07 % Change

201 104

63 94

114 79

B1=26.2677

If on a calculator 26.2677+1.3564%= 26.6239950

Whats the formula?

Also I have 100+ of these to do that all are + different %s

Have been stuck on this, very frustrating thanks for any help!!

So 5000 is the total # of reviews to be done and each day I track the total # of uncompleted reviews... day2=3500, day3=1600, day4=750. Then cell A5 will track the percent complete, I enter 5000 on Day 1 and cell A5 = 0%, I enter 3500 on day 2 and A5 = 30%, 1600 on day 3 and A5 = 68%, 750 on day 4 and A5 = 85%. What formula will I use in cell A5 to calculate this. Thanks.

I am new to this forum. I see lot of active people providing help on various topics. Here is one I need help with.

I want to calculate percent change on a daily basis. Please see the excel sheet attached.

There are two product lines A and B. There are 4 machines in total. Each product line is running on each machine every day. There is one more variable. The quantities are produced and recorded for different Production Lots. In my example I have recorded only two here. The dates are working days excluding holidays and week ends.

If I want to find out percent change of quantity produced for product line A on machine 1 on 09/20/2010 for the lot 09/30/2010, how do I put it in excel functions and formula? I am using Excel 2007.

Your help will be highly appreciated.

Regards,

Atul

I can calculate the formula for this , but the problem comes where for eg there is a loss in Jan 2008 for -95415 and there was a profit in Jan 2007 for 80215. How do I set up formula to take negatives & positives into account in calculating the increase or decrease/

Your assistance or anybody's on the forum will be greatly appreciated

Regards

Howard

http://www.mrexcel.com/forum/showthr...ghlight=howardneed

A survey was given to students asking them to check the colors they like. They could select as many as they wanted among Green, Blue, Red.

For example:

- 7 out of 7 (100%) females in School ABC selected Green.

- 5 out of 7 (71.4%) females in School ABC selected Blue.

- 2 out of 7 (28.6%) females in School ABC selected Red.

- similar data for the males in the school, and for students from other schools.

The data I have is aggregated like so:

School Gender StudentCount Color ColorCount ABC Female 7 Green 7 ABC Female 7 Blue 5 ABC Female 7 Red 2 ABC Male 8 Green 8 ABC Male 8 Blue 5 ABC Male 8 Red 3 etc.In the pivot table I can't figure out how to calculate the percents (7/7 = 100%, 5/7 = 71.4%), etc.

My Pivot table has StudentCount and ColorCount in the data area. My hope was to change the options for ColorCount to show data as the "% of" and select the StudentCount variable, but that's not an option.

Any suggestions? The data with pivot table is attached.

.