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