Posted to microsoft.public.excel.worksheet.functions

Christopher[_3_] Christopher[_3_] is offline

external usenet poster

Posts: 6

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Run a Macro inside a formula	crash20001	Excel Discussion (Misc queries)	5	June 12th 08 08:39 PM
use CTRL key inside a formula	Date Less[_2_]	Excel Worksheet Functions	6	April 16th 08 01:58 AM
I need to use more than 7 formulas inside each other	ghnogueira	Excel Discussion (Misc queries)	4	March 13th 07 01:52 PM
Nesting-Don't use Blanks inside formula	Angela	Excel Worksheet Functions	9	December 8th 05 05:41 PM
Using a value from a cell inside a formula!	marsupilami	Excel Discussion (Misc queries)	5	August 24th 05 07:06 AM

All times are GMT +1. The time now is 08:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us