# Personal Notes or Hidden Text in a Excel Formula

1. ## Personal Notes or Hidden Text in a Excel Formula

====================================
Personal Notes or Hidden Text in a Excel Formula
====================================

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

====================================

Regards,
DILIPandey

< If you liked the tip, please do "vote" / say "thanks" >

2. ## Re: Personal Notes or Hidden Text in a Excel Formula

Thank you very much. It is very useful. I hate to insert comments, therefore your tip is great!

I cannot find "Thanks" button.

3. ## Re: Personal Notes or Hidden Text in a Excel Formula

This forum does not have a thank you button, but look at the bottom left of post #1 and click on the star if you want to add reputation.

4. ## Re: Personal Notes or Hidden Text in a Excel Formula

The Thanks / Like option is available now.

5. ## Re: Personal Notes or Hidden Text in a Excel Formula

What versions of Excel does this work for? Cheers.

6. ## Re: Personal Notes or Hidden Text in a Excel Formula

Well at least 2007+. Does it not work for you in 2003? I do not have 2003 so I cannot test.

7. ## Re: Personal Notes or Hidden Text in a Excel Formula

Seems to be working for me in Excel 2003.

8. ## Re: Personal Notes or Hidden Text in a Excel Formula

does not work in 97

9. ## Re: Personal Notes or Hidden Text in a Excel Formula

Martin try with ISNUMBER. Hope this function available in 97

=3000+1000-500-750*3+ISNUMBER("My Pocket Money + Credits - Food - Qtly Room Rent")

10. ## Re: Personal Notes or Hidden Text in a Excel Formula

yep that works

11. ## Re: Personal Notes or Hidden Text in a Excel Formula

I now notice that using this with Watch Window (2007+2010) is even cooler!!
Thank you for that idea
I find it very "N-abling"
Tynus

12. ## Re: Personal Notes or Hidden Text in a Excel Formula

Hi phnhu76,
Thank you very much. It is very useful. I hate to insert comments, therefore your tip is great!
I cannot find "Thanks" button.
Thanks phnhu76, now as the "Thanks" button is available, please vote (Post Thanks) on the first post of this thread if you liked the tip.

Regards,
DILIPandey

13. ## Re: Personal Notes or Hidden Text in a Excel Formula

Thanks roki4,

If you liked the tip, please vote (Post Thanks) on the first post of this thread.

Regards,
DILIPandey

14. ## Re: Personal Notes or Hidden Text in a Excel Formula

Thanks Tynus,

I now notice that using this with Watch Window (2007+2010) is even cooler!!
Thank you for that idea
I find it very "N-abling"
If you liked the tip, please vote (Post Thanks) on the first post of this thread.

Regards,
DILIPandey

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1