Smart formulas preset spreadsheet?
Smart formulas preset spreadsheet?
(OP)
What I want to do is basically to set up a spread sheet that contains a bunch of formulas.
For example lets us the F=ma formula to illustrate.
I dont know any of these numbers initially...
Is there a way that I can set up a formula that will work out the remaining value if I know just two of these variables.
the first case f= ? I know m and know a
the second case i know f and I know m a=?
last one I know a and I know f m=?
I want to have input cells that I can enter any combination of two variable and get the third one out.
I want to use the minimum number of cells to achieve this too.
How do I do this in Excel.
I have seen it done somewhere I can remember but I want to have a preset spreadsheet with formulas to allow me to plug in known values and work things out with multiple arrangements lying around.
Is this possible?
For example lets us the F=ma formula to illustrate.
I dont know any of these numbers initially...
Is there a way that I can set up a formula that will work out the remaining value if I know just two of these variables.
the first case f= ? I know m and know a
the second case i know f and I know m a=?
last one I know a and I know f m=?
I want to have input cells that I can enter any combination of two variable and get the third one out.
I want to use the minimum number of cells to achieve this too.
How do I do this in Excel.
I have seen it done somewhere I can remember but I want to have a preset spreadsheet with formulas to allow me to plug in known values and work things out with multiple arrangements lying around.
Is this possible?
RE: Smart formulas preset spreadsheet?
Otherwise, you'd need to use some of the Solver and VBA functionality
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Smart formulas preset spreadsheet?
RE: Smart formulas preset spreadsheet?
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Smart formulas preset spreadsheet?
= if (a = "solve",F/m,if(m = "solve", F/a,if(F = "solve", m*a)))
for more complex equations, the same thing can be accomplished in a user defined function.
= SolveFMA(F,m,a)
RE: Smart formulas preset spreadsheet?
RE: Smart formulas preset spreadsheet?
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Smart formulas preset spreadsheet?
Im looking to make a spreadsheet with a lot of formulas. Kinda plug it in to get quick results etc.
I am inclined to go for the 4 cell approach.
3 cells for input and one for out put.
As for TKSolver I have not heard of it but I have blown my budget on MS Project so I can update my skills as everyone seems to want engineers to drive MS Project at the minute.
anyhow
Thanks