See all Microsoft Excel tips
Strategy: There is an old Lotus 1-2-3 function that is still in Excel. This function is the N function. It turns out that N of a number is the number and N of any text is zero. Thus, you can add several N functions to a formula without changing the result, provided that they contain text.
Thus, if you have figured out some obscure formula, you can leave yourself
notes about the formula, as shown in Fig. 387.
Summary: For particularly complicated formulas, leave yourself detailed comments right in the formula.
Functions Discussed: =N()
)