factors

Hi. Urgent as need to hand in tomorrow. Completely lost. I have revenue each day; there's multiple factors; TV ads, radio ads, Facebook likes, Google ads, temperature and precipitation for each day too... In excel- what do I use? What stats to do a quick job on what factors affect revenue...

Looking for some code that will return the closes 2 numbers that are factors of a given number. given number 12: the 2 factor that are the closest to each other are 3 & 4 (not 2 & 6) 24 would return 6 & 4 (not 8 & 3 or 2 & 12) 64 would return 8 & 8 (not 16 & 4) 90 would be 9 & 10 37 would...

Ok so let me start off by saying that I know that this is a common problem but none of the common solutions I've tried are working. I will do my best to describe the problem and I am willing to email the spreadsheet to anyone who thinks that they would be able to help. About the Spreadsheet...

Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me if I make a mistake. Question: How do I multiply a negative number by a positive factor and get a less negative number? Hypothetical Example: -2.0 * 1.1 = -2.2. But...

Hello, thank you very much in advance for your time and charity. In an effort to quantify the best pitching/hitting options for daily fantasy baseball, I'm building a formula/model with 30 factors. For example, the first factor is ground ball percentage (GB%). Based on a low-point of 28.7...

Here is my problem... 2 excel files need to be merged. The new file has updated info i.e. calibration factors of equipment with unique serial numbers. the old file is with old calibration factors and past due dates. Also old file contains calibration factors and due dates not to be updated...

Hi Guys :) I do these days an analytical research and i need some of help in this issue I need to find a way to extract the prime factors of numbers with some special conditions .. Let's take an example to make it much more clear IF i have an an integer number .. let's say 12682 I want to...

My data are like This <tbody> TotalFeed Col1 Col2 Col3 Factor1 Factor2 Factor3 100 (sc-1) 50 25 25 =50/100 =25/100 =25/100 100 (sc 2) 70 =70/100 ? ? 100 (sc-3) 70 15 =70/100 =15/100 ? </tbody> As a matter of math its easy the 30 % remaining will be allocated as 15% and 15 % ...

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

=IF(B4="Y",(IF(BO4="Y",(SUMPRODUCT(Factors!B$8:Z$8,G4:AB4)),0)),0) Can someone please let me know what Factors is doing in the above string?