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