In this article:

How to Add Comments in a Google Sheets Formula (2024 Update)

May 8, 2024

Add Comments in a Google Sheets Formula Using the N() Function

While Google Sheets does not support in-formula comments in the same way programming languages do, you can use the N() function in Google Sheets to include comments directly in your formulas. 

The N() function in Google Sheets is designed to convert text values to 0 and will return any number you input as is. Since it ignores text values, you can use this feature to add comments within your formulas. Here's how:

=A1+B1+N("This is a comment")

In this formula, N("This is a comment") will be evaluated as 0, and therefore, it won't affect the calculation. It serves purely as a comment.

google sheets comments in formula

Note: These comments are not visible in the cell display but only in the formula bar when the cell is selected. 

Add Comments in a Google Sheets Formula Using Notes

For more extensive documentation, consider using cell to add comments in a Google Sheets formula.

Step 1: Insert a Note

Right-click on the selected cell. Look for an option labeled "Insert note".

comments in google sheets formula

Step 2: Enter Your Note

After clicking on "Insert note", a small text box will appear associated with the selected cell.

Type your comment or the additional information you want to include in this text box. There’s no character limit, so feel free to include as much detail as needed.

add comments in google sheets formula

Step 3: Close the Note

Once you’ve entered your note, you can click anywhere outside the note box to close it. The note is automatically saved.

We hope that this article has helped you and given you a better understanding of how to add comments in a Google Sheets formula. If you enjoyed this article, you might also like our articles on how to remove comments from Google Sheets and how to view comments in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->