Ubuntu
openoffice.org package

spreadsheet compound formula

Asked by Riverdarling

 Have installed Feisty working well.

 Am trying to find the formula that works out daily compound intrest.

  Say for augments sake $10.00 @2% daily,compounding?
 Can work it out with pen and pencil or caculator but cannot get it to work in the spreadsheet formula bar.
 Am Learning and have step by step book but just cannot work out ,so am trying to work backwards.
  Any Help much appreciated.
Thank You

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Ralph Janke
Solved:
Last query:
Last reply:
Revision history for this message
Ralph Janke (txwikinger) said : 		#1

Thanks for your question.

Here are some of the possible formulae.

http://en.wikipedia.org/wiki/Compound_interest

Which want do you need to use?

Revision history for this message
Riverdarling (radulfus) said : 		#2

Thanks for the quick reply.
Yes see wikipedia info Tar.
What I want to do is how to work out the compound intrest in the spread sheet.
Rather than use caculater daily,weekly,etc,just put the info into the
spreadsheet and I guess presto!
I hope this is enough info if not do not hessitate to ask more info.
Many thanks
Greg

Quoting txwikinger <email address hidden>:

> Your question #5538 on openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+q
> uestion/5538
>
> Status: Open => Needs information
>
> txwikinger requested for more information:
> Thanks for your question.
>
> Here are some of the possible formulae.
>
> http://en.wikipedia.org/wiki/Compound_interest
>
> Which want do you need to use?
>
> ________________________________________________________________
> _______
> To answer this request for more information, you can either reply to
> this email or enter your reply at the following page:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+ques
> tion/5538
>

Revision history for this message
Riverdarling (radulfus) said : 		#3

Have done some searching around the I/Net and have found a ,allmost,step by step haw to for compound.

This is the link:http://www.thesimpledollar.com/2007/02/24/an-introduction-to-compound-interest-with-spreadsheets-part-2-monthly-compound-interest-aprs-and-apys/

I found,Bit of a mouthful!

Guess this will keep me going for a while.
Thank for all the help
G

Revision history for this message
Best Ralph Janke (txwikinger) said : 		#4

You can put the formula you use to calculate it into the formula-field in the spreadsheet. All the operators are available. When you click on fx you get the list of functions you can use.

Revision history for this message
Riverdarling (radulfus) said : 		#5

Thanks txwikinger, that solved my question.