| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
THANKS!!
- Jeff "Ken Wright" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of all formulas in one column? | New Users to Excel | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
| Color in Excel Formulas | Excel Discussion (Misc queries) | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Linear Mode
