Just do as I suggested and wrap your first formula in brackets, Then
substitute it for the cell reference you have in the second formula

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

becomes

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

and replaces the B16 in

=SQRT(b16/(C12-1))

to give

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"JRH" !o!m!N!OT! wrote in message
...
How can I take two formulas and combine them into one. However, the
result
of the one formula is needed in the second formula?
Formula (1) =E12-(POWER(D12,2)/C12) -- this is being written is cell
b16,
thus the reason I call it in formula 2
Formula (2)=SQRT(b16/(C12-1))

Thanks greatly!

JRH


"Ken Wright" wrote in message
...
Operator precedence means that the division in
(POWER(D12,2)/C12)/(C12-1)
will happen first instead of what you want which is
E12-(POWER(D12,2)/C12)
/ (C12-1), so just wrap the first part in brackets

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"JRH" !o!m!N!OT! wrote in message
...
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)
cell j1=220
cell 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