Clever Way Of Taking Notes in Excel Formula

Clever Way Of Taking Notes in Excel formula - You may already be aware of the function to "insert comments" by right clicking your mouse on a specific cell. 

Most people do not use this often. However, there is another clever way to add your little note into an excel formula.

Excel’s one letter N function is what we will use.

Syntax

N(value)

Below is what formula will return depending "value" argument:

Trick Was in the Last Point

For all other values, the N function will return 0; which can be translated as =N(“text”) function is set to a Zero (for our convenience).

For Instance:

=20*2+3+N(“extra 3 required due to last year’s mistake”) is calculated in Excel as =20*2+3+0.

Happy note taking!