Google Sheets Formulas – How to Add a Note or Comment

formulasgoogle sheets

Microsoft Excel

Microsoft Excel has this feature where one can add a note into a formula with the N() function. It looks like this:

enter image description here

Source: Add Comments to a Formula in Excel for Your Future Reference, Lifehacker.com

Google Sheets

Does Google Sheets have a similar feature to embed notes and comments into a formula?

I'm not talking about the concatenate function which is something different than what I mean.

I'm also not talking about the "Insert comment" feature which is also different.

Best Answer

You can have the same functionality in sheets as well. 

&T(N("comment"))

OR

=IFERROR(A1/A2,"") &T(N("comment"))

OR

=YourFormula+N("comment")

(This last one works when the formula gives numeric results)

Related Topic