Leave A Comment In A Formula

Explanation

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.

Explanation

This formula relies on concatenation to assemble a valid location for the HYPERLINK function.

In cell D5, the link location argument is created like this:

"#"&B5&"!"&C5 // returns ""#Sheet1!A1""

which returns the string “#Sheet1!A1”. The formula then resolves to:

=HYPERLINK("#Sheet1!A1","Link")

Which returns a valid link.

The cell value in column C is entirely arbitrary and can be any cell you like. It could also be hardcoded into the formula as a string like this:

=HYPERLINK("#"&B5&"!A1","Link")

Note: The hash character (#) at the start of the sheet name is required. For more link syntax examples, see HYPERLINK .