Forum Discussion
excel in windows 10.
- Hi, What do you mean by 'order from 1 to 20'? What is 1, what is 30? Kind regards Hans
It can be something of a pitfall. As a 365 dynamic array user, I tend to expect consistency and follow Ray Panko (EuSpRIG papers) in treating any individually edited term as a Latent Error (i.e. one that may deliver the correct numbers now but with no assurance that it will continue to do so during the life of the spreadsheet). I would prefer that all edits should propagate and there should be no option to change a single term, but that would cause howls of protest.
It is not as if any other aspect of traditional spreadsheet development makes an attempt to be robust to change, so the Microsoft default is probably a good solution, though you are correct to warn against the risk.
Working my way, I would have
= IF([@precision]="high",
PI(),
355/113)which, I agree, is somewhat cumbersome.
[x] All edits propagate