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