This page created on Friday, July 15, 2016 by Bill Jelen
This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 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.
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.