LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JRH
 
Posts: n/a
Default Combining formulas and results HELP!!

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of all formulas in one column? Claudia New Users to Excel 1 January 14th 05 12:28 AM
Displaying the results of multiple formulas in a single cell. gallegos1580 New Users to Excel 1 January 12th 05 04:14 PM
How to make a formula display results only if value is greater tha superfooz74 Excel Discussion (Misc queries) 5 December 28th 04 12:40 PM
Color in Excel Formulas Jerry Excel Discussion (Misc queries) 1 December 20th 04 07:11 PM
Copying options: contents, results, formulas, etc. Top Spin New Users to Excel 2 December 20th 04 04:54 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"