Why use defined names?

[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

 

[Alan]

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

 

[Max]

.. 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?

---