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

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

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

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