increase

I need help with a formula in Excel to work out the annual percentage to increase payments for a loan. So if a loan of £2,000,000 is given, the loan payment term is 15 years and the interest rate is 12%. The PMT would be £24,003.36 per month. But what I need to do is allow the lender to pay...

I entered this: =SUM(J7,J11,J15,J19,J23,J27,J31,J35,J39,J43,J47,J51,J55,J59,J63,J67,J71,J75,J79,J83,J87,J91,J95,J99,J103,J107,J111,J115,J119,J123,J127) Can some one help with is there a limit I need to increase etc etc thanks

Dear All, Could u plz assist How to increase size of Check box in excel sheet? Any help, Rgds, aligahk06

Hi, would like to ask if anyone knows how to add 2 spinners for a single cell? For example, the first spinner would be increasing the value by 1 while the other spinner would increase the value in the cell by 0.1. Thus if I want to increase the cell by 20.5%, I would just have to click the first...

I have the following SUMIFS formula =SUMIFS(B5:B23,A5:A23,({"60-90","120+"})) I would like to increase the range to the last column before where "Grand Total" appears The ageing (Criteria is in Col A) I am trying to sum all the values in Col B to the col before Grand Total (last Col)...

Hi, firstly thank you for any help. I am building a tracker that I need help with a formula I want a cell to increase by one for every 5 increment in another cell.

Working on a schedule where I want to increase each cell by :05 (five minutes) Cell A3 would have 4:05 Want cell A4 to have 4:10 A5 to have 4:15 and so on....possible using the fill handle? -------------------- Second option is I would use "two" times in one cell, like this: A3 4:05 - 4:10...

I'm trying to pass the value of a formula to a cell, using VBA, without entering the formula in the cell; for several rows in the same column. I'm trying to use the Evaluate method but it only works using A1 style references; so I'm unable to use R1C1 style like the below code, which works...

Hi I am currently working on creating a model and I am running into some issues. My current method is very time consuming, and when complete will use too many columns and if statements. I want to build a model that calculates the cost of paying raises to certain employees based on a drop...

Hello everyone. Is it possible in this forum for cross posting? max_max

Hi, I'm trying to put together a salary model and need help with a formula which takes into account annual pay rises when calculating each person's monthly costs. For example, worker 1 starts on a basic pay of £1500 per month but on the 1st August each year receives a 3% pay rise and on 1st...

Hi guys, I am building a financial model on a monthly basis. As part of the revenue build I want to grow a percentage at a decreasing rate. For example, over a 12 month period I want the percentage to increase from 50% to 95% with the greatest increase happening at the start and then increasing...

Hello! It's my first time posting here and I don't know if this question has already been asked. If that is the case, I apologize for cramping up the threads and I would be grateful if you'd provide a link to the answer to my question. My situation is this: I have a spreadsheet that consist of...

Hi all, I'm looking to create a count for the number of successive increases or decreases in my data set. I'm not sure if this can be done, and I'm struggling to think of a way to get started on this. Would anyone have any suggestions? Example is below. <tbody> April May June Company...

Hi, I'm new on this forum I've got a problem with a macro used for increasing cells by 1 with the right click of the mouse This is the macro: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells.Count > 1 Then Exit Sub If Not...

I’d like a VBA scirpt to increase a cell value by 1, every time I save & close a spreadsheet. Can anyone provide a script to do so? The cell location is B14 The filename is test.xlsx The file locations is c:\temp Many thanks in advance.

Hello, I'm dealing with the following problem. Say I have a set af values: A B 1 567 2 546 3 567 4 554 5 572 6 543 I can easily determine the average of the values in column B (=AVERAGE(B1:B6)) But I also want to know if the average is increasing or decreasing without making a chart and...

Hi guys, Can anyone help me with this ?? My original VB code is ElseIf brand = "MAC" And year = "2013" Then Profit = 22 / 100 * cost * quantity ElseIf brand = "Rimmel LONDON" And year = "2013" Then Profit = 31 / 100 * cost * quantity ElseIf brand = "REVLON" And year = "2013" Then Profit...

I need to enter a formula that increases the value 1799 (F5) by 20%. Please help! I know it sounds silly but I have such a hard time wrapping my head around percentages =(

I've run into this several times before in a variety of situations. Hoping to find a real solution this time. I have both a combobox and a command button imbedded in my spreadsheet that run macros when clicked. The problem is, every time I click on a control it makes the increases the size of...