Posted to microsoft.public.excel.misc

Eric

external usenet poster

Posts: 1,670

Why use defined names?

If I get a formula (Sqrt(A1*B1)+C1)/D1, and return the result in cell E1. I
need to perform the same kind of calculation from row 1 to row 5000.
Does anyone have any suggestions on whether I should drag the cell from E1
to E5000 for all calculation or I should use the defined name for all
calculation?
Which approach is faster on performance and use less formula memory?
Thanks in advance for any suggestions
Eric

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
defined names	xcel user[_2_]	Excel Worksheet Functions	1	December 14th 07 05:43 PM
Defined names	lesley1000 via OfficeKB.com	Excel Worksheet Functions	3	December 10th 07 02:50 PM
NAMES DEFINED	F. Lawrence Kulchar	Excel Discussion (Misc queries)	5	November 14th 06 07:54 AM
Defined names	DREED	Excel Discussion (Misc queries)	3	March 10th 06 02:55 PM
Using non defined names from another sheet	pQp	Excel Worksheet Functions	6	July 17th 05 11:06 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us