Setting Up A Log Equation
Oct 9, 2009It looks like this (log(X/Y))/log2. The X and Y are celldirections (E2 or F4 and so on). How do i setup that formula in excell?
View 2 Replies
ADVERTISEMENT
Equation Behind The Function
May 9, 2006How do I get to see the equation behind Excel Functions? For instance, the
result of pmt() is not making sense to me, I'd like to see what this function
is doing and how it is calculating its value. Trial and Error is rather
time-consuming and tedious.
1 Equation For 4 Variables
Jul 24, 2012Can I use excel to get make an equation for 4 variables (x,y,z,w)
E.g.
a,b,c,d,3,f,g,h,i, would be constants
w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz
I tried regression but the equation looks like
w = ax + by + cz + c
Is it possible on ay other software e.g MATLAB
SUM IF- Excluded From The Equation
Oct 18, 2007I have the following formula.
=SUMIF(hfx!A:A,"123456789",hfx!J:J)
very simple.
for the totals in J, if there is a (-) negative number, i would like that excluided from the equation.
Using Another Cell's Value In Equation
Oct 22, 2008Lets say I write an equation on my sheet such as:
='A1'!$H422*AH$138
but instead of hard coding the A1 sheet name, I want that to be a value that I can put in a different cell (lets say cell C1) on my same sheet in such a way that it will reference the value in my other cell (Cell C1) and put its value into that equation.
So if I make the value in C1 = A99 then the equation becomes
='A99'!$H422*AH$138
Vba To Get Best Fit Equation Into Cells
Mar 20, 2007i am plotting graphs which i need the equation of the line from. i have been manually typing the x^3, X^2, X^1 and X^0 values into 4 cells which is then used elsewhere, but wanted to know if its possible to get some code to do that for me?
View 2 Replies View RelatedRegress Nonlinear Equation
Nov 20, 2008Below is a nonlinear model, together with calibration data for which I would like to find the parameters Ro, Kc, a and b.
R = Ro + Kc * (1/(1 + exp(-(a + b*lnC))
Calibration Data
C R
0.00.3347
4.80.4201
7.70.5141
11.20.6177
14.40.6887
Given the calibration data above, how can I calculate or at least estimate these parameters?
I do not want to use an add-in program, like Solver, in Excel. I do, however, want to be able to use any existing functions, if necessary, in Excel. i'd appreciate it if someone can walk me through the steps.
Removing Sections Of Equation If Any Value = 0
Jan 13, 2009The equation is basically: 10^[A/20]+10^[B/20]+10^[C/20]. Now imagine that there is no input value for C. I need to make it so that it won't add the bit I've highlighted in green.
View 5 Replies View RelatedGet The Result Of An Equation In A Cell
May 13, 2009I will like to ask, if there is a way to get in a cell the result of a simple equation without having to copy the contents of that cell with a = in front for example if i have in one cell
15*2+35*4+30/2
in the next cell to display the result
185
Multiply And Round In One Equation
Mar 1, 2007I need to take a number, multiply it by a precentage, & then round it to the nearest multiple of 5.
ex:
A1=142.5
B2=A1*50%,(then rounded to nearest multiple of 5)
How To Substitute Cell Value Into Equation
Aug 6, 2012if i obtain an eqn by plotting a graph in excel, etc,
y = 1.22952117E-06x3 - 1.08197863E-05x2 + 9.97531712E-01x + 3.99014495E-01
and i wish to subsitube a cell value from another sheet into the 'x' in the above eqn and i need to do this 20 times.
Move Value To Another Field (with Equation)?
Mar 18, 2013I need to move a value to another field (with equation) and use the output for the same equation till limit is reached..
View 2 Replies View RelatedHow To Add Equation To Dropdown Selection
Jan 11, 2014How to add an equation to a drop down selection if you take a look at the picture in the link supplied, what I want to do is: I want the calculator to take the number in D12 then if the drop down box under it the selection is (as it is) too high then subtract 50 (k11) from D12 and display the answer in D14. I have listed the 3 drop down choices in column L, Lap 2 I would do exactly the same and so on [URL] .........
View 6 Replies View RelatedReferencing The Value In A Cell For A Max Equation
May 20, 2007I have a cell on ' Sheet 2' with the following formula:
=MAX('Sheet1'!C3:'Sheet1'C10)
ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".
Lets say the cell reference C10 is now entered into cell B1 on Sheet 2. How do I modify the above formula to reference B1?
I have tried INDIRECT function but can't get it to work.
Calculate Best Fit Equation Of Curve
May 16, 2008I am trying to calculate the equation of a curve which best fits some data. On the x-axis is date and y-axis the readings. The curve is quadratic, so on the chart I am fitting a 2nd order polyomial and displaying the equation. To prove that the equation the trendline gives me is reasonable, I am applying the equation on the x parameter to get the y parameter estimate and looking to see the error between predicted and actual - see attached.
The equation and the output from it are clearly rubbish, even though on the graph the trendline is a reasonable fit - see attached. Has anyone any ideas why? I think it has something to do with using a date on the x-axis but no idea why. Is there a way to correct for this? I also tried using the following I to calculate the coefficients which came up with a reasonable forecast (although linest should only be used for linear data): =LINEST(C3:C15,B3:B15^{1,2,3})
Equation To Find Top 2 Highest Values?
Mar 8, 2014I have the following 2 formulas that determine the top 2 scores and return the respective headers, but they aren't perfect.
=INDEX(T1:V2,1,MATCH(MAX(T2:V2),T2:V2,0))
The above returns the max, however doesn't take into account scores that are a tie or 0 values
=INDEX(T1:V2,1,MATCH(LARGE(T2:V2,2),T2:V2,0))
The above returns the 2nd highest value, but some instances the output is correct (if there is a tie or a 0).
How can I fix both of these equations and also determine the 3rd highest score?
Result Of Text Equation In Cell
Sep 14, 2007I have two cells (c1 and c2).
c1 contains (2+3*4)*3 without "=" at start.
c2 must contain the result of c1 it means 42.
In the attached file I have a few variants I tried to solve it but they both don't fit.
Formula.xls
Create A Polynomial Equation Of Z From The X And Y Inputs?
Jan 20, 2014I'm familiar with 2d graphs, trendlines, and regression equations. Now I have some tabular data that has 2 input variables and a result. As with my 2d data, I would like Excel to create a polynomial equation of z from the x and y inputs. Can Excel do this, or do I need a plug-in or another software package?
View 12 Replies View RelatedSumif Equation Summing If Contains Certain Word Plus Others?
Aug 18, 2014Is there a way to use =sumif to sum if the cell has the word you are searching for plus other words you haven't identified.
For instance if I have =sumif(a1:a3,"vacant",a:a) , is there a way I can sum if the cell has "Vacant until next week" without me typing the next week"
I have attached a sample spreadsheet.
Inserting Equation Into X Axis Label
Mar 27, 2014I want to show units on x-axis as 10^10 but it will not let me insert equation. How can I do this? I am using the most recent version of excel.
View 1 Replies View RelatedGetting Equation To Apply To Cells Only With Info In
Jul 30, 2014Any way I can get an equation to only apply to cells with information in? E.g. I have two columns, one with 'disposal dates' in and the other with 'extended disposal dates'. I would like to get the difference between them (Extended disposal dates- disposal dates) however not all of them have an extended disposal date, therefore some cells display as '#VALUE!' because its calculating the disposal date-blank cell....
View 3 Replies View RelatedComboBox: Equation In A Column Of Cells
Nov 12, 2008I want to do is a simple list, 2 items, call them "Thing_1" and "Thing_2". I have an equation in a column of cells. The equation is a simple If statement. If the user selects "Thing_1" then the first equation will run, and if "Thing_2" is selected then the second equation will be used. That's it. No more complex than that.
My original questions about how to initialize a ComboBox are cross-posted here: http://www.excelforum.com/excel-prog...ml#post1996135
How To Use Dropdown Menus Pointed To Value In Equation
Jul 18, 2013What I would like to do is use a drop down list Type 1, Type 2, Type 3 etc and then be able to use whatever is selected to reference a value in another cell.
Excuse my ignorance but something like Cell 1 * (If Type 1 from the list is selected use figure in Cell 3, If Type 2 from the list is selected use figure in Cell 4..........) etc etc
Given Points On Curve, Solve For Equation
Feb 25, 2009Is it possible in excel to find the equation for a curve?
I have 6 known x,y data points on a curve. I need to find the equation for the curve.
Solving Algebra (Equation) In Excel
Jun 5, 2003How to do the following, which solves the equation, in Excel.
LH
W1
W2
(LH-X)/(LH+X)=W1/W2
(6-x)/(6+x)=.6/1.25
6*1.25-x*1.25=6*.6+x*.6
7.5-1.25x=3.6+.6x
7.5-3.6=1.85x
3.9/1.85=x
x will equal 2.108..... in this case
Equations :: Solve An Equation For X With Two Variables
Jan 11, 2008Can excel solve an equation for x with two variables.
Example: 102=125000(X-910)/50000.
I need excel to solve for X
The variables are 102 and 125000
SUMPRODUCT Equation Based On Multiples
Mar 4, 2009to create the following formula which I'm now repeating in more elaborate forms. At the moment I am using the formula below but I need to get the bit in red in the second half of the formula to search on more than the one condition.
Currently it is searching a postcode abbreviation field and is picking up all those with 'BS' however I don't just want to search on BS. I would like to search on BS, BA, SN, TA, GL. I have tried putting different combination using commas and plus signs etc in but excel doens't seem to like the way I'm doing it.
=SUMPRODUCT(--(Sheet1!$T$3:$T$10000=A49),--(Sheet1!$S$3:$S$10000="BS"))
Result Of Text Equation In Cell
Sep 14, 2007I have two cells (c1 and c2). c1 contains (2+3*4)*3 without "=" at start. c2 must contain the result of c1 it means 42. I think it has a very simple sulution but I don't know it. In the attached file I have a few variants I tried to solve it but they both don't fit.
View 3 Replies View RelatedCompents Of Chart Trendline Equation
Jun 7, 2008I'm in the middle of designing a sheet that (amongst many other things) takes the equation of a graph trendline, pastes it, and calculates the various values along it. I can do it by hand, but when I try to record a macro, it doesn't register that I've highlighted the equation and hit copy. Here's the code I'm working with:
Sheets("Graphs").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.Select
Selection.Copy
ActiveWindow.Visible = False
Windows("Copy of HRA Design calculator1.xls").Activate
Sheets("Binder @ max. stability").Select
Range("A1").Select
ActiveSheet.paste
The problem is line 4 - it can't copy because the text isn't selected.
Using Trend Equation From Chart In Worksheet Automatically
Apr 24, 2014The trend Equation on a chart is of the form y= a+x.(b+c.x) I want to use that equation in a spreadsheet to calculate value of y for the value of x. I can do it manually by inserting the a+x.(b+c.x) in a cell but would like it to be automatic as the a, b, c in the Equation changes regularly as more data is acquired.
View 2 Replies View Related