# factor

1. ### calculation method

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
2. ### Conditional Formatting - continue CD to next row with a different limiting factor

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...
3. ### Find a prime factor of a number

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...
4. ### Adding logo to multiple worksheets

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...
5. ### Question on UserForms with variable options

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...
6. ### VBA How to multiple data based of identifcation # and date

<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) *...
7. ### Annual discount factor break down

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...
8. ### If-and-how??

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...
9. ### Copy and pasting columns in VBA - with formula adapting to new location

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...
10. ### Inserting user input into Macro inserting new columns

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...
11. ### conditional summation of cells

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...
12. ### Multi-varible summation

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...
13. ### VBA find function for exact percentages

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)...
14. ### Accumulated compound interest rates factor calculation

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...
15. ### Need help with stack multiplication

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...
16. ### Finding factors of a number. Code crashes with big numbers

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...
17. ### Calculating an adjusted factor based on variable values

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...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### 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.

### Which adblocker are you using?

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

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