factor

hello, i would like to know if there’s an equation to help me automatically calculate/multiply any extra 1 percent after 100% with 1.5 as factor for the extra 1 percent

Hi I am tying to continue a CD from top row of a table to the next 100 rows. I have tried the format painter but this holds onto the first row as its limiting factor, and i have tried removing all $ signs but is still not working A1 = 10 B1 = 12 - i want B1 to be red A2 = 15 B2 = 8 - i want B2...

Say I have a number, for example 212, is there a formula which will find me a prime factor, preferably the smallest or else the largest, of that number (without counting 1 or the number itself)? In this case it would be 2. Note that the smallest factor of a number (again, not counting 1 or the...

Hi All, I am using the code below to add logo's to multiple worksheets. It works great until I send the workbooks to my colleagues. The logo isn't visible for them, I believe it's because it is creating a link to the picture in my own personal drive, I want to embed the logo, could I change the...

Is there a way to set up a userform where it will show one option (i.e. a dropdown list) when one factor is selected but show another option (i.e a pure text box) when another factor is selected? Or do I need to create two separate userforms and then depending on which factor is selected that...

<tbody> ID # date price (after code) ID # Date Factor 001 1/1 5 5 001 1/3 2 001 1/2 5 5 002 1/5 3 001 1/3 10 = 5 (Price) * 2(Factor) 001 1/4 10 =5 (Price) * 2(Factor) 001 1/5 10 = 5 (Price) * 2(Factor) 001 ... 10 = 5 (Price) * 2(Factor) 001 1/10 10 = 5 (Price) *...

Hi all, I have the following table to Discount the annual rate to get the present value. I am wondering if there is any formula that i could implement to get the monthly Discount factor so that i can figure out the difference. <tbody> Annual rate 8,00% Discount factor PV...

Hi All I have spent fruitless hours on something that I am pretty sure should be straightforward, please help my sanity :confused::confused: <tbody> 1 AJ AK AN 2 Date expected Overdue? Submitted 3 05/05/2018 07/05/2018 4 16/07/2018 #/N/A 5 05/09/2017 #N/A </tbody> So, I want the...

Hi all, I have the following code to insert a new column: (Code) colLetter = InputBox("Please enter replication factor column:", "Factor column") Columns(colLetter).Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove (/Code) Let's say: colLetter = "M" In the new inserted column, I...

Hi all, I am writing a macro that inserts new columns according to user input. However I come up with an error message when using the user input in the code: (Code) colLetter = InputBox("Please enter replication factor column:", "Factor column") MsgBox colLetter...

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <tbody> Individual Score Score + NF Normalizing Factor AM 2 AM 0.00540 AM 1...

I realize this is very easy for most on this board, but my expertise is quite limited. I would like to build a formula to add a unique normalization factor to scores that that individual has given. <colgroup><col width="100"><col width="100"><col width="100"><col width="100"><col...

Hello, I have a row of percentages: 100%, 200%, 500%, 1000%, 1500%, etc I'm trying to find the cell that has 500%. I use the code below. factor is a number in a cell of which value is 500% Set c = rng.Find(factor, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchFormat:=False)...

Is there a formula to calculate a accumulated compound interest rates factor from/till any given month/year? For example, I have a table with month interest rates: A B 1 Oct/2017 1% 2 Nov/2017 3% 3 Dec/2017 4% 4 Jan/2018 2% 5 Feb/2018 5% 6 Mar/2018 2% So If I wan't to get the accumulated...

I have following data that varies by time: The table below shows the base cashflows at each time <tbody> t 1 2 3 4 5 6 7 8 9 10 11 12 Cashflows CF1 CF2 CF3 CF4 CF4 CF5 CF7 CF8 CF9 CF10 CF11 CF12 </tbody> The table below shows the scaling factor that varies by...

Hi, Can anybody tell me why this code is crashing and also suggest a more efficient code maybe? <code> Function Factors(x As Double) As String Application.Volatile Dim i As Double Factors = x For i = x - 1 To 1 Step -1 If x - (Int(x / i) * i) = 0 Then Factors...

Hi, Here is a table with values from Factor1 to Factor 5. Underneath that, for a specific index, I can mark Y or N for factor values. For instance, for index 1, Factor1 and 2 is marked as Y. The goal is to calculate total factor based on variable and factor values. In this case, variable value...