Add a Comment to a Formula

August 22nd, 2004 | Categories: Formulas | Tags:
-->

A comment can be added to a formula by adding an N function. Or
=Formula+N(“YourTextHere”)

The =N() function returns the number for a given cell. For instance if 1% is in a percentage formatted cell A1, putting =N(A1) in another cell will return the number .01

However when the N function can’t convert the given information it returns 0. So to add a comment to a formula we simply add an N function to the formula, which in turn returns zero, and doesn’t alter the formula in most cases.

This picture demonstrates the use of the N function, added to an existing formula to provide a comment.

formulacomment

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. ganesh
    July 1st, 2005 at 08:39
    Reply | Quote | #1

    pls send with example formulas in excel

  2. Gucci Scarpe
    May 16th, 2011 at 12:43
    Reply | Quote | #2

    This is the correct weblog for anybody who needs to seek out out about this topic. You notice so much its nearly onerous to argue with you (not that I really would wanthaHa). You positively put a new spin on a topic thats been written about for years. Great stuff, simply great!