Most valuable professional
  • Excel Book Excerpt

Excel Add Comments to a Formula

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Add Comments to a Formula

Problem: I spent a great deal of time perfecting the formula shown below. I would like to leave myself notes about it so I can figure it out again six months from now.

LE10000480.jpg 

Figure 472 Will you remember why you added the COUNTIF?

Strategy: An old Lotus 1-2-3 function—the N function—is still available in Excel. It turns out that N of a number is the number and N of any text is zero. Thus, you can add several N functions to a formula without changing the result, provided that they contain text.

If you have figured out some obscure formula, you can leave yourself notes about it right in the formula.

LE10000481.jpg 

Figure 473 Add your comment as text in the N() function.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: