Share via

Writing notes in an Excel formula

Anonymous
2023-03-12T23:18:14+00:00

Is it possible to specify comments inside a formula in Excel, without it damaging the formula?

Similar to specifying comments in programming, within code, using slashes?

If so, I would love to hear how you do it.

Thanks in advance 🙏

Microsoft 365 and Office | Excel | For home | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-03-13T11:14:04+00:00

    Not really. But you might do one of the following:

    1. Add a comment to the cell: Insert comments and notes in Excel for Android
    2. If your formula returns a number, you can use a trick with the N function:

    =expression_that_returns_a_number+N("this is a comment inside the formula")

    For example

    =SUM(D2:D53)+N("We sum the weekly sales amounts")

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-06-07T01:06:06+00:00

    I'll try it. Thanks 😊

    0 comments