Everyone knows about adding a comment to a cell but did you know that you can add a comment directly to a formula?

This could come in handy to give users a reminder of some critical piece of information related to the formula.

For example, to remind users that the formula needs to be array entered:

Data Range
A
B
C
D
E
F
1
Name
Y/N
Bid
-----
Max Yes
Name
2
Sue
Yes
45
77
Biff
3
Carl
Yes
30
4
Tom
No
59
5
Erin
No
61
6
Abbey
No
28
7
Biff
Yes
77
8
Lisa
No
33
9
Paul
Yes
17
10
Ken
No
77


This array formula** entered in E2:

=MAX(IF(B2:B10="Yes",C2:C10))+N("Array Entered - CSE")

This array formula** entered in F2:

=INDEX(A2:A10,MATCH(E2,IF(B2:B10="Yes",C2:C10),0))&T(N("Array Entered - CSE"))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.