View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.