View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel shld allow for coment boxes w/ formulas 'mini popup sheet'

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


On Wed, 19 Sep 2007 08:00:01 -0700, TylerJo
wrote:

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/comm...et.f unctions