Calgarypuck Forums - The Unofficial Calgary Flames Fan Community
Old 11-01-2010, 10:22 PM   #1
iggypop
Powerplay Quarterback
 
iggypop's Avatar
 
Join Date: Apr 2006
Exp:
Default Excel Question

So i'm building an investment excel sheet, but am having problem with one issue.
Is it possible to add an explanation of what is in the cell as well as the calculation?

Something like:

=PV(B5,B6-B40,-1) [pv of $1 Annuity over working years]
with the explanation of the cell being inside the [ ]

I'm just guessing with the [ ] and the error I am getting is "That name is not valid", so not a formula issue.

Is it possible to do this correctly? Any help would be greatly appreciated.
__________________
Quote:
Originally Posted by Temporary_User View Post
Reading the thread title, I simply assumed that Jpold and Jroc came out of the closet and have a love baby together.
iggypop is offline   Reply With Quote
Old 11-02-2010, 08:29 AM   #2
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default

I am not aware of a way to include that information within the formula line, but you could always include it in the cell as a comment.

Select the cell you are interested, right-click and then choose 'Insert Comment'
__________________
"Teach a man to reason, and he'll think for a lifetime"

~P^2
firebug is offline   Reply With Quote
Old 11-02-2010, 08:31 AM   #3
Off The Crossbar
Farm Team Player
 
Off The Crossbar's Avatar
 
Join Date: Oct 2010
Location: Calgary
Exp:
Default

Have you tried using "insert comment" ?
You just have to right click and you can insert a comment about the cell. The comment will be displayed when you hover over the cell and it has a red mark in the top right corner to indicate there is a comment. I have found it very useful in some of my work spreadsheets to explain what is in a specific cell and where it came from, etc.
Off The Crossbar is offline   Reply With Quote
Old 11-02-2010, 08:31 AM   #4
Off The Crossbar
Farm Team Player
 
Off The Crossbar's Avatar
 
Join Date: Oct 2010
Location: Calgary
Exp:
Default

Ah Firebug you beat me to it!
Off The Crossbar is offline   Reply With Quote
Old 11-02-2010, 01:01 PM   #5
iggypop
Powerplay Quarterback
 
iggypop's Avatar
 
Join Date: Apr 2006
Exp:
Default

I was not aware that you could do that. That should work just fine.

Thanks dudes.
__________________
Quote:
Originally Posted by Temporary_User View Post
Reading the thread title, I simply assumed that Jpold and Jroc came out of the closet and have a love baby together.
iggypop is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 02:15 AM.

Calgary Flames
2023-24




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2021