Forum Discussion
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 character>Sales average for the month<special character>*12<special character>Sales for the year<special character>
..where <special character> is the part I can't remember.
This is driving me nuts, please help 🙂
8 Replies
With your permission, take a look at this message, it will help you.
Welcome to your Excel discussion space!
It is very annoying if basic information is not given in the communication.
Excel version, operating system, an Excel file (without sensitive data) and a detailed explanation based on the file sent.
I also wish you much success with Excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- None of that information is necessary.
It is very annoying if you don't even read the question before replying.
- Hi Detlef, no it wasn't. Somehow you could put in any comment, like "The amount of inventory you have in stock"
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
Here is a small example in the inserted file.
Formula: =AVERAGEIFS($B$4:$B$15;$A$4:$A$15;">="&$D4;$A$4:$A$15;"<="&EOMONTH($D4;0))
Additional Informations:
Calculate the average of a group of numbers
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
I do not need help with functions or formulas (thanks though); I need help with putting inline comments in a formula.
Something like this:
=4+5<some special character signaling the start of a comment>"blah comment blah"<some special character signaling the end of a comment>+3
