View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do i calculate the saved amount ?

=FV(3%,5,-3000)

Look in HELP for meaning of the arguments and for other functions in the same family

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bao" wrote in message ...
| Annual contribution US$3000 , Rate of Return 3% , Years of Contribution 5