=formula+N("comment")

To leave a comment in a formula that returns a numeric result, you can use the N function. In the example shown, the formula in F9 is:

=SUM(F5:F8)+N("Q4 numbers are estimates")

This is a tricky use of N() that allows you to use it as a way to leave in-cell comments. It only works for formulas that return numeric results.

The N function takes a value and returns a number. When given a text value, the N function returns zero.

In this case, the primary formula the SUM function, and the N function simply evaluates the comment text and returns zero:

=SUM(F5:F8)+N("Q4 numbers are estimates")=SUM(F5:F8) + 0=410,750

The comment is visible in the formula bar when the cell is selected.

=formula+N("comment")

To leave a comment in a formula that returns a numeric result, you can use the N function. In the example shown, the formula in F9 is:

=SUM(F5:F8)+N("Q4 numbers are estimates")

This is a tricky use of N() that allows you to use it as a way to leave in-cell comments. It only works for formulas that return numeric results.

The N function takes a value and returns a number. When given a text value, the N function returns zero.

In this case, the primary formula the SUM function, and the N function simply evaluates the comment text and returns zero:

=SUM(F5:F8)+N("Q4 numbers are estimates")=SUM(F5:F8) + 0=410,750

The comment is visible in the formula bar when the cell is selected.