increase

  1. H

    Formula to compute increase or decrease and include symbol for up or down

    I have inserted symbols in S1 & T1 to indicate in increase (up) or decrease (down) . Have used the up nd down arrow using Wingdings 3 I have set up a formula to compute the increase or decrease and to include the increase symbol (up sign) and decrease 9down sign) at the end of the formula but...
  2. E

    Values changing with date?

    Hello, I'm hoping someone can help me out with a code I'm looking for. I want certain values on my spreadsheet to increase automatically every year (january 1st). Is this possible with VBA coding? Thanks in advance!:)
  3. Z

    +/- buttons

    Gday ive put my hand up to do stats for my local footy club. i designed something in think to be easy to use, but cant work out how to make my + or - numbers increase or decrease the number next to iT screenshot and excel are here http://thepremiershipclub.wixsite.com/hcfc-stats/blank
  4. AdamSalam

    increase a Value of a Cell depending on its value

    I have one special case, I want to increase some values (deduction from a fixed value), that's the number will be subtracted each time increase the value in question. For example I want to increase any number from 45 - 49 to 50, from a balance of 10. so If I increase 46 to 50 I still have only...
  5. G

    Referring to lookup arguments - best practice?

    Hi, I have tabular data in A5:H11 and in rows 1:3 there are column heading references that are used in formulae in the table below to extract data from other worksheets in the workbook. I would like to move the lookup references out of rows 1:3 so that my table is a single range with no...
  6. T

    Add an amount on to membership, but not if already paying enough!

    Hi, I run a subscription club to a club. We are putting in place new pricing, as there is a huge amount of historical prices in there that we need to get back in line. In summary, the new prices will be £40 per month. Some pay this already, so will hold that rate.. so pay a lot less... as low...
  7. M

    Auto Number increase

    Hello all. i have searched this forum and found things very close, But none of them work for my self. what i need help with is im trying to get a number to auto increase each time the jobsheet is printed, it will also be accessed by more than one computer/user so also needs no write...
  8. A

    Conditional Pricing Formula

    Dear Excel Wizards, Current Scenario Product Price : $50 Quantity : 10 Revenue : $50*10 = $500 However, how do I create a separate row denoting a promotion that shows that the buyer is only paying for 9 quantities for every 10 purchased. This will increase across the columns based on...
  9. M

    Progressive Data Projection

    I use excel to project production across a 12.5 hour shift. The chart is broken down by hours (rows) and columns for projected volume per hour and the actual volume for that hour. I'd like to figure out how to make the projected volume for each hour increase or decrease as the previous hour's...
  10. M

    Increase cell value by set amount with a "button" key

    I have a cell that I would like to increase by "x" amount each time I click on one key. I see I can use a "button" key from the developer design tools, but I think I would need to enter a macro to use that method. Is there a way to do this with out a macro? Using Excel 2010 with windows 10...
  11. J

    conditional formatting icon set

    Hi Guys, I need help. I want to use Icon set - 3 arrows. I want to include an arrow that indicates increase and decrease daily based on it's yesterday data. <tbody> date Cost 12/25 549.38 12/26 821.03 49.45% 12/27 300.23 -63.43% 12/28 360.00 19.91% 12/29 504.00 40.00% 12/30...
  12. T

    How do you create columns that increase by milliseconds?

    I need to create columns that increase in intervals of 33 milliseconds. So, the first column is 00:00:00. 2nd column is 00:00:33. 3rd column is 00:00:66. And so on until I reach 2 minutes. Is there an easy way to do this in Excel?
  13. C

    formula to apply % increase in specific month and calculate month over month change

    Hi there, i am looking for a formula to enter into cells (JAN-DEC) for each row that calculates a % increase and is tied to the effective month column. Is the only solution to do multiple IF statements for each cell? Any help is appreciated. Thanks. <tbody> Core Increase Eff. Month...
  14. D

    Help !

    Is it possible on how to increase the values with hyphens for example (02-01, 03-01, 04-01) and so on accordingly using a formula ? Thank you !
  15. T

    Formula for converting monthly % increase to annual % increase

    So in column A1 I have an average monthly net worth increase of the past 12 months listed as a percent -- 1% In column B1, I'd like to insert a formula that calculates the annual net worth increase rate as a percent based on A1, assuming a net worth constantly grows at 1% each month for 12...
  16. D

    Zero Columns and formulas

    I know how to do the following- just putting it here for reference. Would love to know how to cut and paste a section of excel to show you...but this will have to do. A1: Market Rent B1: Current Rent C1: % Difference Between D1: New Proposed Rent E1: Percentage increase between D1 and b1 F1...
  17. JazzSP8

    Capture cell value before pressing enter?

    Hey All I've a worksheet that I could use some help with. I've been asked to create one that will take the changes to a price and apply those changes across various price breaks. What has been asked is that, if a price in Col P is changed, the same percentage price increase is applied to...
  18. C

    Combo Pivot Chart - Auto-Combine Legend Formatting/Color

    Hello, sorry for the vague title I'm not sure how to summarize what I'm trying to do. I have a line and clustered column combo pivot chart where date is the axis, values are something like "Amount Increase" and "% Increase" and the legend is a Project. A project will have a value for both %...
  19. K

    Need Help with repeating formula

    I am performing a new bid to our current supplier as well as 3 new ones. I have different lanes and am wanting to know the % increase we are possibly going to take. In column D I have the formula to calculate the % increase but need something else extra to have the formula automatically change...
  20. K

    Repeating formula question

    I am performing a new bid to our current supplier as well as 3 new ones. I have different lanes and am wanting to know the % increase we are possibly going to take. In column D I have the formula to calculate the % increase but need something else extra to have the formula automatically change...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top