Excel's yellow sticky note-like comments (Notes) provide one way of annotating your worksheets, but do you ever wish you could write comments in formulas?
Unfortunately, there's no official way, but a workaround does exist involving N. This function converts a non-number value to a number, a date to a serial number, TRUE to 0, and anything else to 0.
N's syntax is as simple as its name β it has one argument called πππππ, and here are a few examples of what it returns:
β =π½(π·πΈπΉπΊπ») returns 12345
β =π½(ππππ΄) returns 1
β =π½(π΅π°π»ππ΄) returns 0
β =π½(π°π·) returns 45160 if A1 contains the date 22/08/2023
β =π½("ππππ ππ π πππππππ") returns 0
N has existed for a very long time, and its original purpose was to provide compatibility with other spreadsheet programs. However, as Excel automatically converts values as necessary, it's not needed anymore for this reason.
It is ideal for inline formula comments, though. Given text strings return 0, there's no interference in calculations as nothing is added or subtracted.
In the video example, the formula =πππΌππ(π³πΈ:π³πΊ)+π½("πππππ ππππππππ β πππ'π πππ πππΌππ. πππ πππΌ!") demonstrates how N can be used. Just use + or - and then affix your N-based comment.
This is the best option we have for now. However, if you've used the Advanced Formula Environment add-in, you'll know that commenting is possible!
β
For more Excel tips and tricks like this, check out our Video Tutorials page.
Conversation
As you comment, let's keep the discussion friendly and respectful to add value to the conversation.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere. uis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.