Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas inside another formula?
Hi all,
Have a quick question - I have the formula =STANDARDIZE(C16,C18,SQRT((C18(1-C18))/C15)) but cells C16 and C18 have the formulas =(C14/$B$14) and =(C17/$B$17) respectively and C15 has the formula =COUNT(JCP!C:C) How can I put these formulas into the above formula? Something about indirect?array? Not to familiar. Any suggestions? Thanks, Chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas inside another formula?
On Thu, 30 Oct 2008 17:44:48 -0700 (PDT), Christopher wrote:
Hi all, Have a quick question - I have the formula =STANDARDIZE(C16,C18,SQRT((C18(1-C18))/C15)) but cells C16 and C18 have the formulas =(C14/$B$14) and =(C17/$B$17) respectively and C15 has the formula =COUNT(JCP!C:C) How can I put these formulas into the above formula? Something about indirect?array? Not to familiar. Any suggestions? Thanks, Chris Just substitute the formulas for the cell references. e.g.: =STANDARDIZE(C16,C18,SQRT((C18(1-C18))/C15)) becomes something like: =STANDARDIZE(C14/$B$14,C17/$B$17,SQRT((C17/$B$17(1-C17/$B$17))/COUNT(JCP!C:C))) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas inside another formula?
On Oct 30, 8:16*pm, Ron Rosenfeld wrote:
On Thu, 30 Oct 2008 17:44:48 -0700 (PDT), Christopher wrote: Hi all, Have a quick question - I have the formula =STANDARDIZE(C16,C18,SQRT((C18(1-C18))/C15)) but cells C16 and C18 have the formulas =(C14/$B$14) and =(C17/$B$17) respectively and C15 has the formula =COUNT(JCP!C:C) How can I put these formulas into the above formula? Something about indirect?array? Not to familiar. Any suggestions? Thanks, Chris Just substitute the formulas for the cell references. e.g.: =STANDARDIZE(C16,C18,SQRT((C18(1-C18))/C15)) becomes something like: =STANDARDIZE(C14/$B$14,C17/$B$17,SQRT((C17/$B$17(1-C17/$B$17))/COUNT(JCP!C:C))) --ron Thanks for the help! Cheers, Chris |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas inside another formula?
On Sun, 2 Nov 2008 06:04:46 -0800 (PST), Christopher wrote:
Thanks for the help! Cheers, Chris You're welcome, Chris. Glad to do it. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a Macro inside a formula | Excel Discussion (Misc queries) | |||
use CTRL key inside a formula | Excel Worksheet Functions | |||
I need to use more than 7 formulas inside each other | Excel Discussion (Misc queries) | |||
Nesting-Don't use Blanks inside formula | Excel Worksheet Functions | |||
Using a value from a cell inside a formula! | Excel Discussion (Misc queries) |