Equation

[crockfighter]

I.m afraid i am a bit of a novice when it come to equations.

I am trying to solve BP = 0.0228*D + 0.0115*L + 0.0555*H + 0.122*S - 3.3256

* = multiplied
I am trying to set up something in excel so that if i enter any of the alphanumerical parameters i.e say BP=.75 excel will return the answer to all of the others, and if i enter the value for "L" excel will return the answer to all of the others and so on.
Is there an easier way to do this without entering formulas in a table format?

thanks

 

[cornflakegirl]

You've got four variables - you can't just give a value to one and have all the rest fall out.

If you enter a value for D, L, H and S, you'll get a value for BP.
If you enter a value for BP and three of the others, you can get a value for the fourth.

 

[Gerald Higgins]

Hi, welcome to the board.

How can Excel (or any other form of calculation for that matter) solve the equation if you are ONLY inputting the value of BP ?
If you are saying you want it to calculate D and L and H and S, knowing only the constants you have provided, and the value of BP, I don't see how that can be done.

Unless there are some hidden principles behind the possible values of D, L, H and S.

If you are saying you wish to input any 4 out of 5 of the variables, then I would think you could set something up in Excel to work out the 5th, whichever one it happened to be.