ExcelBanter - final return!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - final return! (https://www.excelbanter.com/excel-worksheet-functions/172612-final-return.html)

via135

final return!

hi!

if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?

for example

amount - 100
periodicity - monthly
period - 12 months
intt - 12% per annum

thks!

-via135

Suleman Peerzade[_2_]

final return!

1344/- final return.
--
Thanks
Suleman Peerzade

"via135" wrote:

hi!

if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?

for example

amount - 100
periodicity - monthly
period - 12 months
intt - 12% per annum

thks!

-via135

via135

final return!

On Jan 11, 11:07*am, Suleman Peerzade
wrote:
1344/- final return.
--
Thanks
Suleman Peerzade

"via135" wrote:
hi!

if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?

for example

amount * * * * * * *- 100
periodicity * * * * - monthly
period * * * * * * * - 12 months
intt * * * * * * * * * - 12% per annum

thks!

-via135- Hide quoted text -

- Show quoted text -

hi!

i am asking for the worksheet function to arrive at the result?!

-via135

joeu2004

final return!

On Jan 10, 9:48*pm, via135 wrote:
if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?

for example
amount * * * * * * *- 100
periodicity * * * * - monthly
period * * * * * * * - 12 months
intt * * * * * * * * * - 12% per annum

=-fv(12%/12, 12, 100, 0, 1)

See the FV help page for an explanation of the arguments.

Bob Phillips

final return!

=INDEX(A:A,MATCH(lookup_Date,B:B,0)

"namrataparswani" wrote in message news:...
Message-ID:
X-Mailer: http://www.umailcampaign.com, ip log:122.169.22.175
Newsgroups: microsoft.public.excel.worksheet.functions
NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34
Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl!newspe.c om
Lines: 1
Xref: TK2MSFTNGP01.phx.gbl
microsoft.public.excel.worksheet.functions:473979

Bob Phillips

how to use vlooup for date as like

All times are GMT +1. The time now is 10:48 PM.