Why use defined names?

E

Eric

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
 
A

Alan

AFAIK the defined name is faster, but these days with lightning processors
etc, I don't think by much,
Regards,
Alan.
 
M

Max

.. a formula (Sqrt(A1*B1)+C1)/D1, return the result in cell E1
.. or I should use the defined name for all calculation?
Click to expand...

Just curious. In your context, what is the meaning of the above?
 
Top