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!
  1. ganesh
    July 1st, 2005 at 08:39
    Reply | Quote | #1

    pls send with example formulas in excel

  2. 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!