Jul 23 2021 10:22 AM
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 :)
Jul 23 2021 11:57 AM
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.
Jul 23 2021 12:19 PM
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
Jul 23 2021 12:21 PM
Jul 23 2021 12:37 PM
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)
Jul 23 2021 01:24 PM
Jul 23 2021 01:27 PM
Jul 23 2021 02:05 PM
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