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