formulas inside another formula?

[Christopher]

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

 

[Ron Rosenfeld]

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

 

[Christopher]

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

 

[Ron Rosenfeld]

Thanks for the help!

Cheers,
Chris

You're welcome, Chris. Glad to do it.
--ron