Tuesday, February 3, 2009

Adding Hidden Text to Formulas

Imagine you have a formula like: =$2018+$1056-4*$120.

When you initially wrote it you knew what each number represented, but you come back later and can't remember.

Add a hidden note to your formula by using the N() formula

i.e. =$2018+$1056-4*$120+N("My Wage+Bonus-4 weekly loan repayments").

The N() function will convert text to zero.

But be aware not to put * instead of + infront of N i.e *N(" ") since this will be return the amount as zero (similar like numbers multiple with zero value).

No comments:

Post a Comment