< Go Back

Leave a comment in a formula

Want to leave a comment in a formula without disrupting its appearance or functioning? We have got you covered in this regard, see below to learn how to do it in the perfect manner. Here is the formula by which we leave a comment in a formula.

Formula

The syntax to leave a comment in a formula is:

=Formula+N("comment")

Explanation

Here we will use an effective tool in leaving a comment which results in a numeric form. It is one of the most important functions of Excel denoted as N. This function is easy to apply and operates effectively. You need to remember that this method works only for those formulas which generate numeric results.

The N here is quite handy as it lets you leave a comment in-cell without causing any other changes. The N function returns a value when you give it a number, whereas, it returns a 0 if you insert a text value or string in it. It means that both the formula and (N) work together successfully where formula returns a numeric value.

Example

The example given above used a simple and basic formula written below:

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

The evaluation is done in the following manner:

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

=SUM(F5:F8) + 0

=410,750

When you have successfully left a comment, it will become visible as soon as you select the respective cell.

So, this is how one can easily leave a comment in a formula in Excel. Just remember to use the N function as it is the most effective and efficient way of performing this process.

Figure 1. Leave a comment in a formula by following simple and easy steps

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar