New Contributor

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

8 Replies

# Re: Annotate formulas in Excel

@evdryst

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))

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.

# Re: Annotate formulas in Excel

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

# Re: Annotate formulas in Excel

Maybe it were structured references from an Excel table.

# Re: Annotate formulas in Excel

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)

# Re: Annotate formulas in Excel

Hi Detlef, no it wasn't. Somehow you could put in any comment, like "The amount of inventory you have in stock"

# Re: Annotate formulas in Excel

None of that information is necessary.

It is very annoying if you don't even read the question before replying.

yw

# Re: Annotate formulas in Excel

You already ruled out N() or T().

The last suggestion in this thread is LET():