Formula Friday- Add Comments To Your Excel Formulas


Hey all, Friday Formula Time Again….today let’s look at how to easily keep track of what your formulas actually mean.

When you are creating a formula or many formulas as is usually the case in a spreadsheet solution sometimes is would be very useful to be able to have an explanation to remind you, or to convey your logic or instructions  to a user of what your formula is doing.

Excel actually has a function we can use to do this.  The (N) function.  To use it just use the + sign after your formula and what ever you want as your formula in quotes.

See my example below-

The user just needs to click into the cell to see the comment.  So- what is the N function anyway?

N actually will convert stuff to numbers and zeros, but we can use it with text (which represents anything else to zeros in the explanation of the function in the above screenshot).  So, the N is the “comment between the double quotes” as when you add zero to a number, the result is zero- cool.

Do you use this function at all.  Let me know what you think.

 

 

Formula Friday- How To Pick A Winner Using Excel
Formula Friday- Find The k-th Largest Value In Your Excel Data Set Using The LARGE Function
Formula Friday- Use the LEN Formula To Highlight Issues With My Data Import

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts