Wednesday, June 17, 2009

Tip # 50 Hidden text in Formula

By using N() function you can enter hidden text in the formula. It is helpful when you want to display any information along with formula in single Cell.

Example : =2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan repayments")
Output := 2594

Tip Submitted by Harmeet Singh