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).
Showing posts with label Additing additional info in formula. Show all posts
Showing posts with label Additing additional info in formula. Show all posts
Tuesday, February 3, 2009
Subscribe to:
Posts (Atom)