Analytically Solving Equations To Establish Physical Value
Apr 4, 2014
I am trying to analytically solve an equation to establish a physical value. Unfortunately, it's difficult to do the algebra, so it needs to be done this way.
I have an experimental value for this in "J2", so what I want to do is change F2 to that "I2" is equal to "J2"
Is it possible to get excel to match these values - I have about 200 different cells of this?
The formula is in cell "I2"
=B2*((1-(C2/D2)*((F2/G2)^1.2))^-1.5125)
View 11 Replies
ADVERTISEMENT
Oct 24, 2013
I am given the function
y = a x + b
And I am supposed to ask the user to enter a value for a and b twice
So I could have 2 equations and solve them
The problem is I am not sure how to solve the 2 equations using VBA?
View 3 Replies
View Related
Feb 16, 2007
I don't actually own Excel as yet - but I'm wondering if someone could tell me whether Excel is capable of solving what I'm told are 'polynomial equations'. An example of the sort of equation I hope to solve is: d/(1.18 + d) + d/(1.86 + d) + d/(9 + d) + d/(8.8 + d) = 2
d=? {I happen to know d = 3.65(approx) in this example btw}
Often there will be many more than four terms...
View 6 Replies
View Related
Feb 12, 2013
I have a system of 3 equations with 3 unknowns that I would like to solve in Excel.
The equations are
24.792 = A*e^(B/(100-C))
9.857 = A*e^(B/(70-C))
4.590 = A*e^(B/(40-C))
Where e is the exponential function.
View 7 Replies
View Related
Nov 8, 2013
The above formula is not working as in A9, I have a formula although there is no physical text in the cell as the criteria applied is false. However, B9 still appears.
=if(istext(a9),b9,"")
View 3 Replies
View Related
Dec 10, 2013
This was the code I attempted to use previously
Private Sub Worksheet_Change(ByVal Target As Range)
Dim aTabOrd As Variant
Dim i As Long
'Set the tab order of input cells
[Code] .......
View 1 Replies
View Related
Sep 28, 2007
I am using the following code to find out if a file is open or not. The file name and directory is base on a cell value.
Sub SumTransfer111()
'Establish file path and file name based on cell value J5 (say 15204)
fname = Range("J5")
dirname = Int(fname / 100) * 100
dirname = dirname & " - " & dirname + 99
dirnamesub = Range("J5")
Const sRoots As String = "S:MTL_DATAJobs"
Dim sPaths As String
Dim i As Integer
sPaths = sRoots & dirname & "" & dirnamesub & "" & "Job_Cost_Summary_" & fname
'Establish if file is open
Dim blnWorkbookIsOpen As Boolean.,.................
View 2 Replies
View Related
Jun 10, 2009
i'm trying to simulate badminton match with MS Excel..
i just want to make this project simple..
|..A..|..vs..|..B..| Player A vs Player B
Two players compete in a match.The possibility is 50% for both players to win.However,to make it real,each player have their own strength and ability.For this project,i just indicate 3 which is smash power,net power and stamina.[/size]
Ability:Smash
Net
Stamina
Players with more ability have more advantage.How can i relate it with the final score?
Scoring system:2 or 3 set in a match (3rd set is when both tied at 1-1)
A match is the best of three games.
Played with 21 points
If the score reaches 20-all, then the game continues until one side gains a two point lead (such as 24-22), up to a maximum of 30 points (30-29 is a winning score)
In MS Excel:
...|Player A|...vs...|Player B|... <--Player A vs Player B
............|SIMULATE!|............ <--When I click Simulate!,scores appear
| 1st Set | 2nd Set | 3rd Set | <--Here where the scores appear
|............| Smash |............| <--Comparison of ability(can be edited)
|............| Net |............|
|............| Stamina |............|
View 9 Replies
View Related
Nov 23, 2008
per attached I'm trying to establish that values in one sheet are present in another. The MATCH function isn't returning anything.
View 5 Replies
View Related
Jun 5, 2003
How 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
View 9 Replies
View Related
May 5, 2009
Want to write an if then that states if a cell ends with (or includes) .com or .org then = "", if not then = "1".
View 3 Replies
View Related
Mar 16, 2014
Problem solving multiplication of two matrices with entries decimal in vba code:
Code:
Option Explicit
Public MatrixA(30, 30) As Long
Public MatrixB(30, 30) As Long
Public MatrixC(30, 30) As Long
Public RowA As Integer
Public ColA As Integer
Public RowB As Integer
Public ColB As Integer
Function ProperMaticesSizes() As Boolean
[Code] .........
View 1 Replies
View Related
Mar 13, 2014
I have done all the computation and final output was in the form of tables with different solution sets in one worksheet in an excel.
From the dropdown list (List of solution models), when I select one solution set it should pick that particular workout and populate the final output table in the new worksheet in the same excel. Firstly, I need to establish dynamic linkage between the drop down list and final output tables and then push the final table to new worksheet based on the option selected.
View 1 Replies
View Related
Jan 29, 2014
I need to make a cell display the contents of the cell immediately below it, regardless of if there are rows inserted at the referenced row or above or below it on the worksheet. ALSO I need to do this at several additional cell locations down the worksheet. Such as : A1 displays A2, A4 displays A5, A7 displays A8 etc.
Example: I want A1 to display whatever is in the cell immediately below it. In this case A2. I need to be able to insert several rows at row 2 and have whatever new value is now in the A2 position displayed in A1.
After the rows are inserted I need the cell that was in position A4 to continue to display the contents of the cell below it.
I tried using the formula in A1 of: =INDIRECT("A2") and it works good except when I insert the rows my similar formulas below the area where the rows were inserted continue to refer to the specific original cell and not the one positioned now below it.
View 3 Replies
View Related
Nov 13, 2013
I had 4 initial temperature values and after some time i got new temperature values. Now for calculating 2nd iteration i need to use new calculated values and for third iteration values from 2nd iteration is to be used and so on.
How to calculate temperature values directly for 10th iteration without solving each iteration?
View 2 Replies
View Related
May 14, 2006
y = 1.083333333x4 - 7.3333333x3 + 16.416667x2 - 6.16667x + 4
Above is the polynomial equation of a trend line as shown on my chart, I have extracted the numbers into separate cells using LINEST, so now I have in cells A20 to E20 the numbers 1.083333333, -7.333333, 16.416667, -6.16667 and 4 respectively.With a "y" value of 25 how do I go about solving for a value of "x".
I've been stubbornly struggling with this on and off for a couple of weeks now and I'm not getting any closer to working it out and the websites I've found explaining the procedure all seem to go over my head by the time I get into the fourth or fifth paragraph.
View 11 Replies
View Related
Apr 19, 2007
how the Process to solve the following problem:
1A = 15x + 32y + 5z
1B = 6x + 2y + 8z
1C = 3x + 11y + 19z ...
View 9 Replies
View Related
Feb 17, 2003
I was wondering if the solver was the only way to solve implicit equations. I am looking for something that will automatically solve an implicit equation after the appropriate information is entered into the referenced cells.....
View 9 Replies
View Related
Dec 12, 2013
I have three different equations i am trying to combine to one line so I do not have to use three columns.
Equation 1.
If recommend quantity is < 100, and the Number of times part number used is one, then Recomnend quantity was used
Ex =IF(F277 100 and the Number of times part number used is greater then one and less then 10, then Recommend quantity was used
Ex =IF(G277100,*and(E277>1),F277*2.0)
View 1 Replies
View Related
Oct 9, 2007
I am trying to solve a set of simultaneous equations by using SolverOk function in VBA.
I dont want to use the 'SetCell' option so, I wrote the following
SolverOk MaxMinVal:=1, ByChange:= Range("V34:V36")
SolverAdd CellRef:=Range("AK4:AK6"), Relation:=2, FormulaText:="0"
SolverSolve
but I get an internal memory error. However, if I use the solver dialog box directly from excel and not through a macro and keep the 'Set Target Cell' as empty, I get the right solution.
View 8 Replies
View Related
Mar 30, 2014
I'm trying to find definitions/commands to make excel find the best combinations of several defined scopes and restrictions to make an output number as high as possible.
This is by using a combination of several different equations, maybe excel has a magic trick for all the variables and formulas.
Attached File: forum_heatexchanger.xlsx
View 2 Replies
View Related
Mar 17, 2014
I have two cells with the following equations:
H3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,13,FALSE)," ")
I3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,10,FALSE)," ")
In an adjacent cell, I am trying to use an if statement
J3=if(and(H3<1,I3<1),"yes","no")
I am not getting a return in cell J3.
View 3 Replies
View Related
Jan 11, 2008
Can 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
View 9 Replies
View Related
Nov 6, 2006
is it possible to export a trendline equation from a graph to a cell, or at least to export the coefficients? If yes, how?
View 4 Replies
View Related
Dec 26, 2013
I am about to take a corporate finance course. The textbook uses a ton of basic (complex to me) equations to calculate interest rates, bond premiums, dividend reinvestment scenarios, etc.
I know that Excel has a bunch of specific functions to calculate interest, NPV, etc. but I am NOT interested in using those because I would like to have Excel "do the math" once I enter the formulas (or parts of formulas) correctly.
how to enter the equations below into Excel without using built-in formulas (I'm also not looking to use the Equation editor because I actually to calculate the answers, not just have the visual look/feel of the equation).
1R2 = [(1 + .0194)(1 + .03)]1/2 - 1
If done correctly, 1R2 in the above should equal 2.47%. I am totally fine doing parts of this in separate cells if necessary.
And something more complicated like the below. I wrote out the word "delta" because I don't know how to create the "triangle" symbol for delta on this forum post. According to the text, for securities with semiannual receipt (compounding) of interest, it is represented as:
-D = (delta P / P) / ((delta r sub b) / (1 + (r sub b)/2)))
Or in English, I believe that can be expressed as "negative D equals the quotient of delta P divided by P (in the numerator) divided by the following: delta r sub b divided by the quantity 1 plus r sub b divided by 2"
And finally
V sub b = 1000 / [1 + (.10/2)]2(4) + 50 times the following compound bracketed expression [1 - (1 / [1 + (.10/2)]2(4)] divided by (.10/2)]
View 3 Replies
View Related
Aug 22, 2009
I need to automate the attached as per the following (by not recording macro unfortunately).
Sheet one has a dump of data. First, I need to change the data format from yyyymmdd to dd/mm/yyyy. Then I need to filter for region EU and only copy the filtered data from columns A, C-D, F and the difference from columns I-J to Sheet 2. Then in Sheet 2, I need another column to calculate the difference per unit.
View 9 Replies
View Related
Mar 26, 2009
Combining two equations with MOD function for UPC check digit calculation.
I wanted to combine these if possible,
View 4 Replies
View Related
Aug 6, 2014
Any way to exclude colored cells from addition in a column. I will attach a simple example document.
I am building a spreadsheet to keep track of my monthly spending, and debt balance. I keep track of the total amount of bills I pay each month. As I pay them, their respective line is highlighted green in the spreadsheet. I would like to create a macro/formula which would sum the remaining cells in the column which are not highlighted to display the remaining monies which need to be paid out. I'm not sure if this matters but I am using office 2010.
billSample.xlsx
View 4 Replies
View Related
Dec 31, 2013
I had a question about adding numbers, sort of like algebra equations (best description I can think of) into a spread sheet. Example:
Cell A1: 8
Cell A2: 8l
Cell A3: 8ls
Cell A4: 8l
Cell A5: 8
Cell A6: -where I want the total to be displayed in the following way: 16+16l+8l
Is this even possible to calculate by grouping like numbers?
View 2 Replies
View Related
Jan 13, 2009
I am using the following equation to add together up to eight different sound levels:
=10*LOG(10^H14+10^I14+10^J14+10^K14+10^L14+10^M14+10^N14+10^O14)
It works perfectly, except that due to the nature of the equation, if there are no values entered for any sound levels the answer will be 9. Is there any way to check to see if any values are present? I've been looking into IF functions and I've tried (unsuccessfully):
=IF([=10*LOG(10^H14+10^I14+10^J14+10^K14+10^L14+10^M14+10^N14+10^O14)]=9, 0, [10*LOG(10^H14+10^I14+10^J14+10^K14+10^L14+10^M14+10^N14+10^O14)])
View 6 Replies
View Related
