You can use your personal notes in a formula to remember the details of the figures getting calculated there.
For example, if a hostel student receives $3000 as pocket money, $1000 takes as credit, incurs $500 on food and pays rent of $750 p.m for a quarter can note down these details in a formula as shown below:-
=3000+1000-500-750*3+N("My Pocket Money + Credits - Food - Qtly Room Rent")
From above formula, it gets clear that function N can be used for including notes within formula which would be hidden unless a user selects that cell and finds these notes in formula bar 🙂
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Great Tip to help you know what you thaught when making complicated Formula, I like it!
This seems like a really useful tip, but the result I get is #NAME?
What am I doing wrong?
Hey Tom,
Pls try below formula ( just copy and paste )
=3000+1000-500-750*3+N("My Pocket Money + Credits – Food – Qtly Room Rent")
and let me if still you getting the #NAME error...
many thanks
Rishi Saw
If copying the formula from the article, you must replace the smart quotes with straight quotes
it's really an useful tips.
wow, never come this in mind. good one.