Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

jjonesal (Programmer) (OP)
6 Nov 05 11:52
I’ve got a Lotus worksheet that has this formulas in one of the cells:

1/@FV(1,C14,C15)

I’m trying to understand how Lotus interprets this…. I would have expected to see the @ symbol as the first character in the cell to denote that a formula was being used. If anyone can point me to a reference or help with this, I would appreciate it.

Jan

danswindow (IS/IT--Management)
7 Nov 05 9:09
The yhe formula is 1 divided by @FV(1,C14,C15). The following is from version 5.0's help section on formulas.

@FV(payments;interest;term) calculates the future value of an investment, based on a series of equal payments, earning a periodic interest rate, over the number of payment periods in term.

I hope this helps some.
danswindow (IS/IT--Management)
7 Nov 05 9:13
Oops, The first line should be "The formula is 1"
jockopa (TechnicalUser)
30 Nov 05 21:50
I aggree with you that the "1" should not be in front of the @ sign, but can't explain why it is.  I have an old book that explains the @FV formula this way:
@FV(payment, interest, term)

The @FV function calculates the future value of a series of equal payments, where "interest" is the interest compounded each period and "term" is the total number of payments.. For example, if you plan to deposit $10,000 a year for 10 years into an account that earns 12% simple interest per year, you can use the function:
@FV(10000,.12,10) to determine what your account will be worth at the end of that period. The account will be worth $175,487 at the end of 10 years.
The @FV function uses the following formula to calculate future value:payment*(((1+interest)^term)-1)/interest.
This calculation assumes that you make each payment on the last day of each period.
The @FV Function in 1-2-3 release 2 evaluates to ERR whenever the term argument is less than 1. The problem is corrected in later releases.

Hope it helps some....

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close