computation problems -- formulas
 

=E12-(POWER(D12,2)/C12)

=c12-1

=SQRT(b16/c13)




I want to write the above formulas into one single formula but I keep
getting hung up on subtracting 1 from the cell in c12

How do I get the cell c12 to subtract the value of 1, so that it becomes the
new value in the equation but is not changing the actual value in c12?



Logically:



I have 200 in cell c12 I want to subtract 1 from c12 so that the value for
computation becomes 199 and then I sqrt the value in cell b16/c12-1. The
value in cell c12 remains 200 it does not change I just need to automate
that whatever number is in c12 would be subtracted by 1 during the
computation I'm wanting to do this all in one formula





Help? Any ideas



Thanks -



JRH

Hi
Do you mean
=E12-(POWER(D12,2)/(C12-1))

HTH
Michael

"JRH" wrote:

=E12-(POWER(D12,2)/C12)

=c12-1

=SQRT(b16/c13)




I want to write the above formulas into one single formula but I keep
getting hung up on subtracting 1 from the cell in c12

How do I get the cell c12 to subtract the value of 1, so that it becomes the
new value in the equation but is not changing the actual value in c12?



Logically:



I have 200 in cell c12 I want to subtract 1 from c12 so that the value for
computation becomes 199 and then I sqrt the value in cell b16/c12-1. The
value in cell c12 remains 200 it does not change I just need to automate
that whatever number is in c12 would be subtracted by 1 during the
computation I'm wanting to do this all in one formula





Help? Any ideas



Thanks -



JRH

Close, but I need to take the sum from the calculation
=E12-(POWER(D12,2)/(C12)) and then sqrt that divided by (c12-1).
=E12-(POWER(D12,2)/C12)=SQRT(b16/c12-1) . So my question is how do I
combine all this to happen in one line? Rather then generating the product
from =E12-(POWER(D12,2)/(C12)) in one cell and then doing another operation
SQRT(b16/c12-1) in another cell because I have to get that result from the
initial equation and put it into the second equation.

Thanks greatly!!



"Michael" wrote in message
...
Hi
Do you mean
=E12-(POWER(D12,2)/(C12-1))

HTH
Michael

"JRH" wrote:

=E12-(POWER(D12,2)/C12)

=c12-1

=SQRT(b16/c13)




I want to write the above formulas into one single formula but I keep
getting hung up on subtracting 1 from the cell in c12

How do I get the cell c12 to subtract the value of 1, so that it becomes
the
new value in the equation but is not changing the actual value in c12?



Logically:



I have 200 in cell c12 I want to subtract 1 from c12 so that the value
for
computation becomes 199 and then I sqrt the value in cell b16/c12-1. The
value in cell c12 remains 200 it does not change I just need to automate
that whatever number is in c12 would be subtracted by 1 during the
computation I'm wanting to do this all in one formula





Help? Any ideas



Thanks -



JRH

one way:

=SQRT(E12-(POWER(D12,2)/C12)/(C12-1))


one way to approach this is to enter the intermediate step in another
cell, say J1:

J1: =E12-(POWER(D12,2)/C12)
B16: =SQRT(J1/(C12-1))

Then copy the formula in J1 after the = sign, and paste it into B16 in
place of "J1":

B16: =SQRT(E12-(POWER(D12,2)/C12)/(C12-1))

In article ,
"JRH" !o!m!N!OT! wrote:

Close, but I need to take the sum from the calculation
=E12-(POWER(D12,2)/(C12)) and then sqrt that divided by (c12-1).
=E12-(POWER(D12,2)/C12)=SQRT(b16/c12-1) . So my question is how do I
combine all this to happen in one line? Rather then generating the product
from =E12-(POWER(D12,2)/(C12)) in one cell and then doing another operation
SQRT(b16/c12-1) in another cell because I have to get that result from the
initial equation and put it into the second equation.

Thanks, but I'm still stuck?????

=SQRT(E12-(POWER(D12,2)/C12)/(C12-1))
The above result of the above formula does not return the same value as
splitting the operation into two.


=E12-(POWER(D12,2)/C12) --- returns 220
Now, the above returns 220, I need that 220 to complete the second equation.
=SQRT(J1/(C12-1)) --- =sqrt(220/199)
j1=220
c12=200

So, How do I combine the result that is being generated in j1 into the
equation in the cell j1 to be all on the same line, rather then two lines.


Thanks -

JRH

What do you mean "combine the result...in j1 into the equation in the
cell j1"? If the result is already in j1, what are you trying to
accomplish?



,
"JRH" !o!m!N!OT! wrote:

So, How do I combine the result that is being generated in j1 into the
equation in the cell j1 to be all on the same line, rather then two lines.