Excel shld allow for coment boxes w/ formulas 'mini popup sheet'

[Guest]

Sometime you want to tie out a number but you don't want to insert lines and
a worded discription is too long. I want to suggest a feature that would
essentially work the same way that inserting a comment would, however, within
the comment you have cells that you can pull numbers into from the sheet and
add functions to in order to show how the number in the orignial cell was
calculated. This would save haveing to insert column that are need in an
otherwise standard template or have to write a very long worded explaination.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Gord Dibben]

Maybe something like this?

=a2*a1+n("days worked in A1 * daily wage in A2")

Everything after the "n" will not be shown in the cell but you can see it in the
formula bar.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks for the tip, I didn't know that one and that will come in handy. What
I was trying to describe would be just like a comment box in the way that
there would be a small triangle in the corner of the cell and when you put
the focus on the triangle a box would pop up. Instead of seeing just text you
would see a two column (or more) grid that would esentially work like a new
sheet.

So if I had a number

59,000
10,000 <----Comment Box--------------------
2,000 -- 100 - Days --
-------- -- 10 - DpD --
71,000 -- 10,000- Totl --
---------------------

Then if you clicked into were the 10 was you would could still use a
formual, for instance maybe that 10 dose come from Sheet two, but you don't
want to show it on Sheet one. There are many ways around this as fair as
having the information there, but not have it show (hiding rows or columns)
but where my though was that I do not want to change the spread sheet AT but
I want to be able to electronicly be able to review a brief break out of a
figure. The same way a comment box lets you explain it.

Just a thought.

Thanks for the reply, I will be using your tip!

Cheers