How to Add a Comment to a Formula

Automate Excel

How to Add a Comment to a Formula

A simple way to add a comment to a formula for later reference is to add the following to the formula N+(“YOUR COMMENT”). By way of an example, =SUM(A2:A4)+N(“This is”).

Related posts

3 Responses

  1. dave Says:

    And if you’re returning text:

    =”some text”&text(”comment here”,”;;;”)

  2. Hui... Says:

    This only works provided you put text in the N() function
    If the N() Function evaluates to a numeral as in =10*10+N(10*10)
    it returns 200 as it should,
    as the N function returns a number
    =10*10+N(”10*10″) returns 100
    Better and safer to use Cell Comments

  3. Social Wonders Says:

    Great !!

    I was looking for something like that since long time.

    Thanks

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.