View Single Post
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

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