The simplest use of the FORMULATEXT function is straightforward formula auditing.
Excel gives the answer 10. If you have a mathematical background, you’ll know why Excel gives a different answer to such a simple calculation — and why, technically, Excel is right. If you don’t have ...