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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Have A Cell Be Blank If... 2
reverse pasting rows with alternate blank cells 0
How to save the cell formula memory on worksheet? 0
column to row draging 1
How to determine the values? 1
relative offset to a named cell 3
date comparision 0
Copy/Paste formulas in merged cells 2

Top