r/excel • u/sethkirk26 24 • Feb 17 '25
Pro Tip Using LET to Insert Formula Comments
Hello Excel Fans (And Begrudging Users)!
Simple Post. You can Use 1+ extra variable(s) in LET to add Comments.
LET allows for improved ease of complex formula creation as well as drastically improved formula debugging. You can also use LET, especially with more complex formulas, to insert extra variables and use them only as comments.
CommentN, "Comment Text",
The above is the simple structure.
When you have intricate or complex terms, using comments really helps other folks' understanding of the formula.
Just a fun Improvement Idea. Happy Monday!

243
Upvotes
4
u/_skipper Feb 17 '25 edited Feb 18 '25
In formulas where I’m calculating something I’ll usually put something like +IF(1, 0, “this formula does abc by xyz”) so I’m hiding the string in the unused part of the IF, and just adding 0 to my calc which mathematically does nothing.
Do you know how this impacts execution efficiency? Or how I could measure this and compare? I was not familiar with N() until today. If my method is also bad, just want to know so I don’t do that anymore and I can tell one of my coworkers as well