Annotate formulas in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2580803%22%20slang%3D%22en-US%22%3EAnnotate%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580803%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20a%20while%20ago%20I%20read%20a%20tip%20on%20how%20you%20could%20annotate%20your%20formulas%20in%20Excel.%20It's%20not%20an%20actual%20comment%2C%20nor%20it%20making%20use%20of%20the%20N%20function.%20It%20was%20something%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DAVERAGE(A1%3AA5)%3CSPECIAL%20character%3D%22%22%3ESales%20average%20for%20the%20month%3CSPECIAL%20character%3D%22%22%3E*12%3CSPECIAL%20character%3D%22%22%3ESales%20for%20the%20year%3CSPECIAL%20character%3D%22%22%3E%3C%2FSPECIAL%3E%3C%2FSPECIAL%3E%3C%2FSPECIAL%3E%3C%2FSPECIAL%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E..where%20%3CSPECIAL%20character%3D%22%22%3E%20is%20the%20part%20I%20can't%20remember.%3C%2FSPECIAL%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20driving%20me%20nuts%2C%20please%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2580803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581331%22%20slang%3D%22en-US%22%3ERe%3A%20Annotate%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111222%22%20target%3D%22_blank%22%3E%40evdryst%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20a%20small%20example%20in%20the%20inserted%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%3A%26nbsp%3B%20%3DAVERAGEIFS(%24B%244%3A%24B%2415%3B%24A%244%3A%24A%2415%3B%22%26gt%3B%3D%22%26amp%3B%24D4%3B%24A%244%3A%24A%2415%3B%22%26lt%3B%3D%22%26amp%3BEOMONTH(%24D4%3B0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20Informations%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcalculate-the-average-of-a-group-of-numbers-e158ef61-421c-4839-8290-34d7b1e68283%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECalculate%20the%20average%20of%20a%20group%20of%20numbers%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581378%22%20slang%3D%22en-US%22%3ERe%3A%20Annotate%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20need%20help%20with%20functions%20or%20formulas%20(thanks%20though)%3B%20I%20need%20help%20with%20putting%20inline%20comments%20in%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D4%2B5%3CSOME%20special%3D%22%22%20character%3D%22%22%20signaling%3D%22%22%20the%3D%22%22%20start%3D%22%22%20of%3D%22%22%20a%3D%22%22%20comment%3D%22%22%3E%22blah%20comment%20blah%22%3CSOME%20special%3D%22%22%20character%3D%22%22%20signaling%3D%22%22%20the%3D%22%22%20end%3D%22%22%20of%3D%22%22%20a%3D%22%22%20comment%3D%22%22%3E%2B3%3C%2FSOME%3E%3C%2FSOME%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581379%22%20slang%3D%22en-US%22%3ERe%3A%20Annotate%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111222%22%20target%3D%22_blank%22%3E%40evdryst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20it%20were%20structured%20references%20from%20an%20Excel%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2581399%22%20slang%3D%22en-US%22%3ERe%3A%20Annotate%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2581399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111222%22%20target%3D%22_blank%22%3E%40evdryst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWith%20your%20permission%2C%20take%20a%20look%20at%20this%20message%2C%20it%20will%20help%20you%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20is%20very%20annoying%20if%20basic%20information%20is%20not%20given%20in%20the%20communication.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EExcel%20version%2C%20operating%20system%2C%20an%20Excel%20file%20(without%20sensitive%20data)%20and%20a%20detailed%20explanation%20based%20on%20the%20file%20sent.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20also%20wish%20you%20much%20success%20with%20Excel%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

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

 

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.

@NikolinoDE 

 

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

@evdryst 

Maybe it were structured references from an Excel table.

 

@evdryst 

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)

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

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

@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