Forum Discussion

Copper Contributor

Jul 23, 2021

Annotate formulas in Excel

Hi, a while ago I read a tip on how you could annotate your formulas in Excel. It's not an actual comment, nor it making use of the N function. It was something like: =AVERAGE(A1:A5)<special char...

excel

Formulas and Functions

Detlef_Lewin

Silver Contributor

Jul 23, 2021

evdryst

Maybe it were structured references from an Excel table.

evdryst
Copper Contributor
Jul 23, 2021
Hi Detlef, no it wasn't. Somehow you could put in any comment, like "The amount of inventory you have in stock"
- Detlef_Lewin
  Silver Contributor
  Jul 23, 2021
  evdryst
  You already ruled out N() or T().
  The last suggestion in this thread is LET():
  https://stackoverflow.com/questions/35203307/how-to-add-comment-inside-complex-excel-formula