# inflation

1. ### How to pull a sheet name from a cell and use to calculate just one sheet in vba

Hi All, I have a large workbook that has a sheet which calculates results with and without inflation. I have code that changes inflation to 0 and then back to what it was originally. Before I copy the original assumptions back I need to calculate just one sheet that is selected in a drop-down...
2. ### Update prices automatically on a specific date

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...
3. ### Auto update cell price for inflation

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...
4. ### Auto update cell price for inflation

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually...
5. ### Update prices automatically on a specific date

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at \$1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks
6. ### Inflation formula with varying rates per year!

Hello, I am looking for a formula that properly pulls a Baseline Expense depending on location (this part is done) and then multiplies it by looking up the inflation rate for a given year. Second half of the formula is below. Inflation portion...
7. ### Conditional format last row of positive value in table

Hello, I have a table with 40 rows and depending on input the values change from positive to negative. So with an inflation rate of 2.5% then row 23 will be the first row in negative numbers, if I change inflation rate to 1% then row 28 will be the first row in negative. How do I conditionally...
8. ### Defined Range Name Recalc using drop down list

I have a "Pivot Table" with 6 columns A thru F. header = Fiscal Years. There is a row A thru F for total costs in each Fiscal Year. I have defined that range/row as Total Costs. I want to take each Total Costs and bump it up by an inflation rate without have to go in each cell and add the...
9. ### Measure can't decide if it's a date??

I've got a date measure that works with some operators but not others. Perhaps someone can tell me what I'm doing wrong in formatting? I get an error that the date measure is a text measure and DAX cannot compare text and dates, but only for certain operations. I've got an inflation formula...
10. ### Best way to create and use constants in Power Pivot?

For my model I have constants to be applied such as projected inflation rate, depreciation years, and other values to be set by users as what-if options. There are too many variations the users want to create disconnected tables - e.g. listing every inflation rate by hundredths of a percent -...
11. ### forecast monthly change of inflation rate

Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...
12. ### Cumulative Inflation Impact on Unit Price

I'm looking for a formula that gives me an average unit price value that considers annual inflation. For example: Inflation is 2% Year 1, Unit Price is 100.00 Year 2, Unit Price is 102.00 { =100*1.02 } for an average unit price of 101 { =(100+(100*1.02))/2 }. Year 3, Unit Price is 104.04 {...
13. ### Adjusting for inflation on Excel

So I have an excel problem (first time user) and I have to adjust for inflation for a fortnightly payment. So the payment comes in every fortnight and its \$900. Inflation is estimated approx. 4% and its to occur on a yearly basis on and after 1/07/2014 (so the next one would be 1/07/2015 and...
14. ### Compound interest taking inflation into account

I am interested to know whether there is a compound interest formula which takes inflation into account. I am familiar with the compound interest formula. The type of calculation I'm looking to do is Monthly investment of: \$250 Annual interest rate: 4% Annual inflation rate: 3% Period of...

### This Week's Hot Topics

• Get External Data (long shot question!)
This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
• Importing multiple excel files into one spreadsheet
Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
• Cell Formatting
Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
• How to copy multiple rows using If
Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
• Workbook_Change stopped working !
I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
• VBA If statement
Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...