Determining a Value of a Cell

Why should I use the N-function?
In all the shown cases the internal value is the same as the value, the N-function delivers. You can see this, if you format the cells to "standard".
You can even calculate with these values. So it is easier to add a zero for the true/false values and format the cells to "standard".

Enno

Another Excel function similar to N is T(arg). If arg is text, T returns arg; otherwise, T returns a null string ("").

To add a comment to a cell formula:
For a numeric or logical formula (represented by ...), use
    =N("comment") + ...
which adds zero as described in the Tip. In this case a logical formula will return 1 for TRUE and 0 for FALSE; if you want to return TRUE/FALSE, use
    =OR(N("comment"), ...)
With a text formula, use
    =T(N("comment")) & ...
which prepends a null string ("") because N("comment") returns zero.

To make a cell formula Volatile (update each time Excel recalculates):
For a numeric or logical formula (represented by ...), use
    =N(T(NOW())) + ...
which adds zero because T(NOW()) returns a null string (""). In this case a logical formula will return 1 for TRUE and 0 for FALSE; if you want to return TRUE/FALSE, use
    =OR(N(T(NOW())), ...)
With a text formula, use
    =T(NOW()) & ...
which prepends a null string ("").

My Excel Toolbox includes MyFavoriteExcelNotes.PDF with randomly collected, poorly organized, and occasionally updated information like this;
see https://drive.google.com/open?id=1OYSSMYKh5Dh6zb69gel2pUK6HxIXxKu7
And see https://sites.google.com/view/MyExcelToolbox/

So that's how you add notes to a cell! I always thought there must be a way.
Thank you, Allen, that's really going to help me a lot in documenting my spreadsheets.

I've always wished there was a way to add notes inside formulas. After all, it's common in programming. Little did I know there is one! Thank you very much.

Love the use of N() for commenting.

I've always thought Excel needed a way to do in-formula comments, kind of like you can with using a single quote in VBA.

Using cell comments (now called notes) seems too heavy-handed and interferes with the end-user experience.