Adding comments/notation to a formula?

[mxavery]

I've googled around and the only thing that seems to populate is the "N() formula", which shows the comments, and that's not what I want. I'm just trying to add notation to my formula, so if I need to reference it in the future, I don't forget what pieces of the formula does what lol.

Is there a way to add text notation in a formula that doesn't affect the actual formula? Sort of like, CSS notation where you type /* comment here */?

[TMS]

Maybe something like this.

=LET(n_r, "Range to be used", r, B:B, n_fr, "filter range for non blank entries", fr, FILTER(r, r<>"", "no data"), fr)

[curiouscat408]

AFAIK, the answer is no. That is why people use the N() function.

N("this is a comment") returns zero. So we can add it to any numeric expression, and it "doesn't affect the actual formula".

Likewise, T(N("this is a comment")) returns the null string. So we append it to any string expression, and it "doesn't affect the actual formula".

Some care might need to be exercised, especially if you add comments that way in the middle of expressions instead of just at the end of a formula.

The performance impact should be negligible.

Of course, alternatively, you can add a comment to the cell. But that might not help when you want to document "pieces of the formula".

[ByteMarks]

Following from post#2, you can with, additional spacing, make quite good pseudo comments using LET

=LET(REM,"/*This formula adds two numbers together*/",

     A1+B1
)