increase

Good morning, I've been given a task at work and am having a little bit of trouble with copying a countif formula. The formula starts off as =COUNTIF($D$2:$D$885,"31/03/2017") When I copy the formula I want the date associated with the formula to increase by one day each time. So the next...

Hi all, I was wondering if i could get your advice. Is there a way to automatically increase a numerical value in "column A" by 5% without having to add another column to do the calculation within VBA. I haven't come across any Google topics that can answer this question.

Good morning, I am trying to figure out a shorter formula for figuring out what a 2% increase a year would be for the first 4 years and then a 1.5% increase for the final year. I have a value in A1 i.e. 73688 in C1 I have a value from 1 to 5 telling me what the salary increase would be for that...

I have a table with 32 columns to determine costings. Originally, it was going to have just one row and using that, my table was performing calculations etc correctly. There is a checkbox that allows a 10% increase to be put on the price. With only 1 row, I just set it so that if you clicked...

Hi, I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest...

Hi, I'm looking to increase the size of the margins in my cell, particularly the vertical. i.e. - I want there to be more white space between the rows. When I select Format cells, sometimes the text tab is there to be able to change those margins, but many, many times, it's not. Is there...

Is there a way to put an initial time in a cell and then have the subsequent cells increase by one minute interval? I am currently using excel 2010.

The value in column F is 1000. The value in column D is 21.14. Each time I increase the value in F by 1000 the value in D should also double, E.G. – F = 2000 then D = 42.28 and so on. Is there a formula I can place in column G that will calculate the base amount in column D each time I change or...

I need help with a formula that will help spread a percent increase over a 12 month period. Basically I am working on a budget template where I want to increase a number by an annual percentage but spread that increase over the entire 12 month period. Example: I have a value of 100 and want...

I have a cell with the value 125% in it, however I need to make the cell display the words "INCREASE BY 25%". Example: If cell A1 = 100, from a pull down menu in cell A2, I want the user to be able to select "INCREASE BY 25%". Having selected "INCREASE BY 25%", the value of cell A1 then needs...

<tbody> product code Jan price Feb price MAR PRICE % / Different 132 10 10 11 ?? 399 12 12 12 398 9 8 15 </tbody> Hi All I have some sales data.As the table above. I would like to see if price same for 3 month it shows "nothing" in the last column. if price are...

I am creating an inventory/stock control sheet for a client. They have 100-130 items they want to run a stick control on. Then once they have the starting numbers they want two buttons on each row, one to increase the Qty and the other to decrease the Qty by 1. So far I have created the first...

I am calculating % movements between sets of numbers usingthis formula: =IFERROR(IF(ABS((B1-C1)/C1)>5,””,(B1-C1)/C1),”-“) I now need to add conditional formatting to the formula (orsomewhere) that will apply different formatting depending on which range ofcells and the result: Turnover Range...

Hi I have various properties let out to various tenets . The tenancy are of various periods eg some may be 1 year or others may be 3 ,5, 10 years when date the rent increase may be yearly or every 2 or 4 years from the start of the contract. Is it possible to have an excel spreadsheet to...

Hello I have a work book with two tabs. 1. Contractual Rent Steps - This shows the annual cost per square foot. 2. Market Rent Steps - This will use the annual market cost per square foot with a 3% increase when the tenants Contractual annual rent step increases. What I am trying to do is...

Hi all, This one has stumped me and I can't find the answer online. I need to sum a series that increases by a percentage each period. However, the percentage it increases depends on the number of periods. I.e., if it needs to increase from 80K to 100K over 3 years, the annual percentage...

First time poster. Hopefully, I'll make sense. In cell d49 I have +sum(fixture!l2:m11) In cell e49 I have +sum(fixture!112:m21) How do I write a formula to increase this across each cell value by 10? ie: f49 = shows a range of l22:m31 etc, I need to go across to column ao49 Any help more...

Hi All, I am having trouble trying to work this one out. I can't figure out the formula that goes in the green cells highlighted below. In the green cells I want to increase the cost base of each property by the % from the data below, based on whether the property is allocated as a house/unit...

I need solution for increasing Nested-If limit more that 07 Please help

Hi There. I'm looking for an excel formula that, instead of rounding up to the next whole amount, it will round up to a SPECIFIC pre-selected tenths and thousandths place "cents." See below first column is a sampling of random prices prior to an increase. The second column is using the...