Free Microsoft Excel 2013 Quick Reference

calculate percent increase

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


Good morning to everyone...(or whatever time of day it may be)

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


Hi,

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.

I have to get calculate 6.70 X 10% Est. Percent Increase Or Decrease on excel and I don't know how. Could anybody please help? Thank you.

I am trying to add a formula in Excel to show a percent increase or decrease in sales from one month to the next and I can't figure out the formula...Columns are: month and total sales(in dollars). I need to compare month 2 to month 1 and show how much the sales increase or decreased on a percentage basis (Ex: January $10,000 and February $15,000...the answer I want is a positive 50%.)

Thanks.

Going back to my math days, we have 4 tests that we give during the year. I am trying to find the percent increase from the beginning to the end of the 4 tests?? Am I on the right track with my formula?? Is there one formula that can do this?? It has been a long time since college! In my example the percent increase would be 11.22%?? Not sure.

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.

How could I do a percent increase when I have two tables with money values,
one from last year and one from this year?

What do you do if both values are negative I just can't figure this out. I'm working in a spreadsheet and I am calculating % of increase of decrease. My formula is working great, here's an example:

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!

Hello, I am doing a project in which I need to calculate the percent difference for a set of numbers. I already did the regular numbesr but I have no idea of how to calculate the percent difference for Blood pressure reading since they in the fraction form, when I plug the equation it says "error value" can some one help me with the formla to calculate the percent differece for blood pressure reading (systoly/diastole)

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

I have a data dump in Excel that contains service packages offered in different areas (Systems). Each package has different combination rates based on the services offered in each package. I would like to calculate the rate percent of each service as a part of the whole package (subtotal) for that area. The file has a considerable amount of line items.

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.

Please see attachment. In this example, in Column D I want to calculate the percent difference between the numbers in the last 2 columns (Column B and Column C). BUT I want a formula that will automatically update if I were to insert a new column between Column C and Column D. So as a result, new numbers would go in Column D and the percent difference would now be in Column E.

I need to calculate the percent difference between cells and columns and am unsure what formula to use. For example, I might need to know the percent difference between cash fundraised in 2004 and 2002, and I need to have the percent change as the totals for the cash raised change. I'm not sure if I'm explaining this correctly, please let me know if no one understands.

Thanks for the help!

Hi

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

Hello,

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 a worksheet that has the current years profits in column B, the prior years profits in column C and the % increase/decrease in column D.

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.

Hi everyone,
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.

I need help to write a complex formula and would greatly appreciate
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

I have been working on a model that does a calculation of 5 numbers. All of these 5 numbers are calculations themselves from an earlier step. My problem lies in the fact that if i increase the amount of decimals displayed for those 5 numbers, it changes the final outcome. How is that possible?

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

Hi

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

Ok so A1=1.3564
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!!

I have data that I want to track % complete. EX: A1=5000, A2=3500, A3=1600, A4=750
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.

Hey Guys,

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 want to calculate the percent of people responding 1-3 on a 5 point likert scale. I would also like to eliminate non-response (blank cells) from the calculation. Is this all possible in one formula? I appreciate the help.

I have a spreadsheet where I need to calculate the increase in % one year over the other in column D for Eg if Profits are 95415 in Jan 2008 (Column B) and 80215 in Jan 2008 (Column C), then the % Increase will be (95415-80215)/80215 *100

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

I am trying to use multiple response data in a pivot table.

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