Thank you. I know that changes in values that are not passed as arguments do not lead to recalculation of a function result.
But don't you think that in the book it is written in a little misleading way? Let me explaine, the author uses vague language - "at times, it may return an incorrect result.". It may look like description of a floating bug or something like that. While he could have clearly specified cases where result is always incorrect. Lets compare:1. "Excel’s calculation engine can’t account for ranges in your code that aren’t passed as arguments."
2. "Excel’s calculation engine can’t account for changes in ranges in your code that aren’t passed as arguments."
Do not you think that 2-nd sentence is correct while the 1-st is not?
What is your opinion? To be honest I am not completely sure that I am right in my logics and proposals, my English is not that perfect to understand all subtle meanings.
Thank you for your help.
Bookmarks