Why use defined names?

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
AFAIK the defined name is faster, but these days with lightning processors
etc, I don't think by much,
Regards,
Alan.
 
.. 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?

---
 
Back
Top