Hi all, I have a relatively large spreadsheet which references to other cells a fair bit.
For instance each row in Column D will check if the value in Column A is 1. Is it better / faster / more efficient to reference as =IF(Indirect("a"&ROW())=1 etc or simply =IF(A1=1,) copied all the way down?
I'm more interested in the speed and file size either option would impact on
Aside from the fact that your formula is needlessly complicated, INDIRECT is volatile, which means it recalaculates anytime anything changes, whether it needs to or not.
Entia non sunt multiplicanda sine necessitate
Hi Kevin,
INDIRECT is a Volatile Function .
If you want speed, avoid volatile functions wherever possible.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thanks for the words of advice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks