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).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment