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 char...
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