There are times when Microsoft Excel fails to work as intended, and as such, the best you can do in some situations is to reset the application back to factory settings. Out of all the other methods, ...
If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...