How To Use Excel N Function

    how to use excel n function

    Quick Intro

    Want to add a comment in your formula? Just use N Function.

    Excel N Function help you to convert a non-number value into a number. In below example, I have used N Function to convert TRUE to number 1 and FALSE to 0.

    Definition of Excel N Function

    Syntax

    N(value)

    value A non-number value which you convert to a number.

    More Information on Excel N Function

    • In real life, N Function doesn’t have any usage as excel can automatically convert non-numbers into numbers where needed. But you can use this function for a magical trick. Check out the example.

    Example

    In the below example, we have used N Function to insert a comment into a formula.

    When you input a text in N function it will return 0 which have no effect on calculation. And, you have a nice technique to insert comments in your formulas for future reference.

    examples to understand excel n function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel N Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    Apart from this, I have a list of excel functions and some real life formulas examples.