| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why use defined names?
AFAIK the defined name is faster, but these days with lightning processors
etc, I don't think by much, Regards, Alan. "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why use defined names?
.. a formula (Sqrt(A1*B1)+C1)/D1, return the result in cell E1
.. or I should use the defined name for all calculation? Just curious. In your context, what is the meaning of the above? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| defined names | Excel Worksheet Functions | |||
| Defined names | Excel Worksheet Functions | |||
| NAMES DEFINED | Excel Discussion (Misc queries) | |||
| Defined names | Excel Discussion (Misc queries) | |||
| Using non defined names from another sheet | Excel Worksheet Functions | |||
Linear Mode
