Find Future Value of a Savings Account

I am trying to set up a spreadsheet that determines the future value of a 
savings account.
0
6/14/2005 5:25:04 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
705 Views

Similar Articles

[PageSpeed] 0

Take a look at the FV function in XL Help.

In article <EC8EEB72-AF22-47D8-A266-839CA9356725@microsoft.com>,
 "gingerjane" <gingerjane@discussions.microsoft.com> wrote:

> I am trying to set up a spreadsheet that determines the future value of a 
> savings account.
0
jemcgimpsey (6723)
6/14/2005 10:57:06 PM
Reply:

Similar Artilces:

Saving existing Outlook emails
I'm needing to re-format my harddrive and am wondering how I can save my existing Outlook emails and settings so that once I have the newly reformatted drive setup I can access my saved emails and files? do a search in your hard drive for *.pst... it contains all e-mails and contacts... in brief, all eggs in one basket. If you have mail rules you can export them, as you can your mail account(s). HTH <anonymous@discussions.microsoft.com> wrote in message news:10fe01c4a73d$16a62f50$a301280a@phx.gbl... > I'm needing to re-format my harddrive and am wondering how > I can ...

Document not saved #5
I am trying to save a spreadsheet. Everythgin seems fine excpet for the message "Document not saved" Why is it telling me this and how can I save my work? I have tried saving it to different places and I still get the same message. Hi John, SYMPTOMS When you attempt to save a workbook, you may receive the following error message: Document Not Saved CAUSE This problem may occur when the following conditions are true: The workbook was created from a template that contained an embedded object. -and- You have inserted a worksheet into your workbook from...

Workflow rule on (Order)Products and columns of related entities in advanced find view
Hi, Does anyone know whether it's possible to create workflow rules on (Order)Products, since the entity Products isn't part of the standard workflow entity? In my example I have added a new (expiry) date attribute on the OrderProduct form. Now I would like to add a workflow rule on that datefield to create a task when the expiry date is nearly reached; but the problem I have is that i can't "reach" the fields on the OrderProduct form to put a workflow rule on? Another problem I have is that I've created an advanced find query in which I query customers who have or...

Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it is bad mojo to do that. However, I have pay data that I calculate and input to a database and it must be able to be reconciled with our ADP data. So I need the ability to change and fix the data so it does not change as a result of recalculations. I have a form with a field that calculates the pay based on hours and pay rate. I have another field (the "copy" field) next to that one that has the control source set to the database field. I have set the default value of that field to be equal to the...

reflecting values in a column into a row
I am creating a chart to map a round-robin chess game. If there are 4 players, then all 4 has to play one another. if I have the names John Mike Sally Bill Then I'd like to type them into a columns and write a formula in a row to pick up the names the spreadsheet should then look like this: John Mike Sally Bill John Mike Sally Bill I think it may be achieved with the Indirect() function, but my Excel 2007 help seems broken and I can't figure it out without an example. Thanks. MikeB With names in A2:A5 Enter in B1 =INDIRECT("A"&COLUMN(B1)) Or...

Not able to open imported accounts 4.0
We have a situation where we've updated a client from 3.0 to CRM 4.0 and have an import that brings in new Accounts. Unfortunately, we can open accounts that don't have a parent account but can't open the parent account itself. In essence, we have two accounts with another one the parent - we can open ones that show the parent, but again, we get an error - see yor administrator. Is there a rights issue or relational setup we're missing. ...

save as problem
I cant save my excel file The "save as" option is not eviable. Whats happening? "From a prior post by Ron DeBruin, You can reset your menubar to default. Right click menubar. Customize > Toolbars Tab. Select worksheet menubar. Click Reset button. Using VBA Application : CommandBars(""Worksheet menu bar"").Controls(""File"").Reset Or the whole menubar Application.CommandBars(1).Reset You lost the things you add to the menubar!!" ========================================================== And one link that offers some sugges...

Second E-Mail Account (Address)
I have set up a second e-mail account using the same POP3 and SMTP servers (provided by the ISP) as I used to set up the first e-mail account. The first e-mail address is working fine, but when I send an e-mail to the second address (from the default account), it does not appear in the Inbox. The e-mail does appear in the Sent Items folder with no errors. How do I access the second account to receive/send e-mails? Thank you for your solution(s). ...

Integration Manager
Using Integration manager i am able to insert fixed allocation accounts for general ledger. However, if i have to make changes to these accounts, say if i want to change percentages and then update the old percentages with the new ones, the updates fail when i use Integration Manager. Error Message displayed - xxxx-xx-xxxx distribution account already exist. Can anybody tell me why is the updates fail and how to overcome it? And please note that integration is set in "INSERT & UPDATE" mode. Doc, Integration Manager does not update transactions. That drop down option should ...

Outlook 2007: When i Save a New Rule outlook Change it automatically...
Hi people! I have this problem with Outlook 2007. I have 15 e-mails addresses in my outlook, but i can=B4t create the rules for send all the received mails to each emails folder. Example: I want to create a simple rule that move all the e-mail that i get from "example1@example1.com" to the folder "Inbox/ example1@example1.com". When i create the rule, all works fine, i select the correct e-mail account name, the correct destination folder, etc... but when I hit the SAVE button in rules window, Outlook 2007 changes the account automatically to another one. Not automatically...

need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is (How Many Days). Now I need to a assign a default value, or expression (not sure which way to go about this) that will take the date value for (Date) and add the value (How Many Days) I figured that the formula should read =sum([Date]+[How Many Days]) But that is not giving me any results, thanx for your help in advance =DateDiff("d", Date(), [How Many Days]) -- Wayne Manchester, England. "J Man" wrote: > I have made a form in which I input different values. On of the values is ...

Emails don't find contacts in restored Outlook
My hard drive burned up, so I replaced it, reinstalled, and imported everything into Outlook. The contacts are there if you click contacts. However, when sending emails, there is no way to connect to my contacts. It's like they are invisible. You never import Outlook data to restore it. You just open the Outlook data file. When you do, you will be able to configure your address book view to display your Contacts the same way as always: http://support.microsoft.com/default.aspx?scid=kb;en-us;287563&Product=ol2002 -- Russ Valentine "Mike Row Soft" <MikeR...

column value translation
I'm sorry if this is already here somewhere, but I could't find any references. I need to upload a list of people into our computer system and this list is comprised of their names and the code for the branch where they work. The computer system into which I need to upload this list will not recognize the current branch ID code for those employees, but I do have a list that is basically a comparison of the two different codes. For example branch code 800 on the list equals branch code C001 in the system. I need to get a way in excel to convert all the branch codes that are next...

restore accounts
A user accidently deleted some accounts. What's the easiest way to get them back? I have the backup of all the databases. Please indicate. Thanks. Hello Jun, there is no way to restore the accounts except restoring a backup of your crm-database. For the future you should forbid deleting in the security role...then the users only can deactivate the accounts (thats the recommended way, instead of delete). Mario > A user accidently deleted some accounts. What's the easiest way to get > them back? I have the backup of all the databases. Please indicate. > Thanks. > ...

Fill cells with interpolated values
Hi What is the easiest way to fill cells with linear interpolated values ? e.g. i have value 5 in cell A1, and value 15 in cell A6. Cells A2 ... A5 should now be filles with 7, 9, 11, 13. of course, it's not a big deal to write a formula for interpolation, but maybe there is more simple way, (just by some mouse clicks....?) Biff Select the range A1:A6 with your start and stop value in their respective cells, and then do Edit / Fill / Series / Trend / Linear -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/...

some replies come from default account
Some email replies from me come from the address to which the email was sent and others come from my default address. For example if I reply to a message that came to kozmo@thisaddress.com, the reply comes from kozmo@defaultaddress.com. I can change it manually for each reply but that's a pain and if I forget to it's a problem. Not all messages behave this way. Some come from the correct "reply from" address. I can't figure out what the difference is for those that come from the correct address. I'm using OL2000 on XP, Internet Mail Only. Any ideas what'...

Someone must have asked this before but I can't find it!
Being a relative Excel newcomer I,m not sure of all the terminology so may have used the wrong terms when searching. What I am trying to do is create a worksheet in which a cell shows one of 3 values (LOW,AVERAGE or HIGH) according to the value in the cell to the left of it, which itself is the sum of the 2 preceding cells. To be more specific, cell D6 is Men, E6 is Women and F6 is"=SUM(D6,E6)". I then want G6 to show "LOW" if F6 is less than 5, "AVERAGE" if it is between 5 and 20, and "HIGH" if it is over 20. If anyone understands the question and can h...

Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved? I know you can do this in word but is it possible in Excel 2002? Here is an UDF Function DocProps(prop As String) application.volatile On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function Now you can use the following formula in one of your cells: =DocProps("Last save time") Obviously, the file has to have been saved. -- HTH Bob Phillips ... looking out across Poole Harbour to ...

XML Deserialize of empty value
Hello, I'm encountering a strange issue when deserializing a piece of XML. If I have the following XML and try to deserialize it, everything works: <page> <format>Letter</format> <margin>1</margin> </page> If I have the following XML, everything works: <page> <format></format> <margin>1</margin> </page> BUT if instead I have the following XML, the "margin" element is always 0: <page> <format /> <margin>1</margin> </page> Why...

investment importing & "recover account"
Hello. I'm using 2006 and am unable to directly connect to Principal Financial Group to directly download my account transactions. I've been downloading my transactions in a .qif file and am trying to use the recommended "recover account" approach to import the investment transactions. When Money opens the file, however, my Principal account, which is in my money file with transactions, is not listed. The only account listed as available to import the transactions is one other investment account that is a single stock - held by itself. Why would my account not be list...

Search and display a value from a XMLDOCUMENT
Hi I have the following XMLDOCUMENT loaded in memory: <Datos_de_INGC011_CAT_INDICADORECONOMIC> <INGC011_CAT_INDICADORECONOMIC> <COD_INDICADORINTERNO>317</COD_INDICADORINTERNO> <DES_FECHA>2010-06-28T00:00:00-06:00</DES_FECHA> <NUM_VALOR>517.51000000</NUM_VALOR> </INGC011_CAT_INDICADORECONOMIC> </Datos_de_INGC011_CAT_INDICADORECONOMIC> And I need to retreive the value in <NUM_VALOR>, I had tried of many ways, but I can´t do it, Please somebody h...

Retrieving values from lookups
Hello All, Is it possible to use client side scripting to achieve the following? If not, what is a good approach for handling this. On the Case record there is a field called responsiblecontactid which is a lookup. When a contact is selected we want to pull specific attributes from the Contact record onto a few custom fields on the Case. Specifically phone and email. Any information anyone has is greatly appreciated! Hello: If you are interested in custom solution for your requirements, Please drop a email to know more information. Regards, Manick ERP Specialist zslinc, USA mani...

I need help assigning a value to a character
I need to format a cell so that if I enter an upper case "Y" it display the "Y" but the cell thinks the value of the "Y" is "1" so that it ca be added in another function elsewhere. I have tried to use the "IF functions but have had no success as of yet. HELP -- billybo ----------------------------------------------------------------------- billybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2661 View this thread: http://www.excelforum.com/showthread.php?threadid=39881 in cell a11 type in =SUM(IF(A1:A10=...

Update values in close opportunity form
Hi, I want to update the values in the drop down of the close opportunity form. I want to add/remove the values in the status reason field Is there any way I can do this? Thanks Eddie Not using the default crm forms. You have to build a custom aspx page calling the webservice for this. The CRM SDK has some details on this look for the SetStatusRequest -- Patrick Verbeeten (MCSD) Lead Developer Aviva IT Web: aviva-it.nl "eddieg@uniqueworld.net" wrote: > Hi, > > I want to update the values in the drop down of the close opportunity > form. I want to add/rem...

Run Time Error on trying to save workbook
This code worked perfect when it was in the User Form Code Window, but I moved it to a module and I get a Run Time Error "424' Object Required Code in the User Form Window -------------------------------------------------- '******************************************************* 'Save Installer Forms 11 Control Button 'Located in M3_Save_Workbook '******************************************************* Private Sub Save_Installer_Forms_11_Click() Call Save_Installer_Forms End Sub Code Located in the module: Declarations -----------...