Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have seen Excel spreadsheets with a section above the worksheet for adding comments or to track the progress or changes on the worksheets. The comment section I am talking about is completely independent of the worksheet and changes in the worksheet do not affect the comment section at the top. I'm not sure if this is from a more expensive version that I do not have or if it is an add on. Any help appreciated.
Solved by I. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/03/2018 - 08:39
Hello :)
User 13/03/2018 - 08:42
Are familiar with what I am describing?
Excelchat Expert 13/03/2018 - 08:42
Yes, it sounds like a text box
Excelchat Expert 13/03/2018 - 08:43
Does that sound familiar?
User 13/03/2018 - 08:43
I don't think it is a text box.
Excelchat Expert 13/03/2018 - 08:43
Can you desribe it a little more please.
Excelchat Expert 13/03/2018 - 08:43
What do you mean by a comment section at the top?
User 13/03/2018 - 08:44
Similar to the Excel spreadsheet having two sections.
Excelchat Expert 13/03/2018 - 08:45
When you scroll down does the comment section stay visible?
Excelchat Expert 13/03/2018 - 08:45
For instance, if you scrolled to row 100, can you still see the comments?
User 13/03/2018 - 08:45
Yes it is not in the worksheet
Excelchat Expert 13/03/2018 - 08:45
Does it have separate cells or is it just one big comment box?
User 13/03/2018 - 08:46
between the worksheet area and the formula area. I have seen it say in an accountant's office from a distance.
User 13/03/2018 - 08:46
It appears you are able to add a date then comment then move to the next line to do the same.
User 13/03/2018 - 08:46
Like there are two worksheet areas.
Excelchat Expert 13/03/2018 - 08:47
Okay, can you tell me what your intended use is for this comment section?
User 13/03/2018 - 08:48
Just that to date and document changes to the worksheet and expected deadlines or responses.
User 13/03/2018 - 08:48
And to be able to scroll back to familiarize myself after not touching the worksheet for a space of time
Excelchat Expert 13/03/2018 - 08:49
I see. based on your description, I thought it was a text box. You can achieve the same by using a textbox at the top while locking the scroll view, but it will be within the sheet at the very top rather than on above the formula bar.
User 13/03/2018 - 08:50
Yes, but it will be blocking out the menu or parts of the worksheet. What I am trying to describe was built in and Excel made space between the menu and the worksheet.
Excelchat Expert 13/03/2018 - 08:51
I'm reviewing, but haven't found anything in relation to that.
Excelchat Expert 13/03/2018 - 08:51
I'll continue reviewing though.
User 13/03/2018 - 08:52
I thought it would be something to add or a box to check under the developer tab or view tab or options tab but I have not found anything so I decided it must be an add in.
User 13/03/2018 - 08:54
Makes me feel better it was not an easy answer for you!
Excelchat Expert 13/03/2018 - 08:54
Yes, sorry. I wish it was :(
User 13/03/2018 - 08:55
When the time runs out then our time is over?
Excelchat Expert 13/03/2018 - 08:55
Yes, you can extend the session. However, I don't feel that I will be able to answer this for you.
User 13/03/2018 - 08:56
OK! Thanks for listening!
User 13/03/2018 - 08:56
Have a good day!
Excelchat Expert 13/03/2018 - 08:56
Have you ever used the comments option?
Excelchat Expert 13/03/2018 - 08:56
by right clicking on a cell and inserting a comment that goes with the cell?
User 13/03/2018 - 08:56
Comment that appear in the cells?
User 13/03/2018 - 08:56
Excelchat Expert 13/03/2018 - 08:57
Ah, okay, that is the only alternative suggestion that I have at this time.
User 13/03/2018 - 08:57
Ok thanks!
Excelchat Expert 13/03/2018 - 08:57
You're very welcome!
User 13/03/2018 - 08:57
The next time I see it, I will inquire.
Excelchat Expert 13/03/2018 - 08:58
Okay, please do :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc