+ Reply to Thread
Results 1 to 14 of 14

Personal Notes or Hidden Text in a Excel Formula

  1. #1
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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" >
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  2. #2
    Registered User
    Join Date
    05-14-2012
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    11

    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. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    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.
    HTH
    Regards, Jeff

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Personal Notes or Hidden Text in a Excel Formula

    The Thanks / Like option is available now.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    125

    Re: Personal Notes or Hidden Text in a Excel Formula

    What versions of Excel does this work for? Cheers.
    B.Econ, CFA

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    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. #7
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2003
    Posts
    125

    Re: Personal Notes or Hidden Text in a Excel Formula

    Seems to be working for me in Excel 2003.

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Personal Notes or Hidden Text in a Excel Formula

    does not work in 97
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  9. #9
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    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")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  10. #10
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Personal Notes or Hidden Text in a Excel Formula

    yep that works

  11. #11
    Registered User
    Join Date
    04-25-2012
    Location
    Glastonbury, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    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
    Last edited by Tynus; 07-10-2012 at 07:26 AM. Reason: Noticed another angle

  12. #12
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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. #13
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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. #14
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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