This is one of the most concise Microsoft Excel functions, consisting of just one letter − Ч (N). At the same time, it is very useful, because. performs a simple but important action – turns its argument into a number. In practice, this can be useful, for example, to add a text comment directly to the formula. For this:
- Stretch the formula bar vertically to fit more than one line.
- Select the cell containing the formula. and place the cursor in the formula bar after the formula.
- Press combination Alt+Enterto move to another line within the formula.
- Add a function to a formula Ч with a comment as an argument (don’t forget the quotes).
The trick is that if you specify text as an argument of the function N, then it turns into zero, therefore it does not change the result of the original formula in any way, but adds a comment to it.
- How to make a complex formula more visual
- Convenient viewing of formulas and results at the same time
- Convert numbers-as-text to full numbers