The best thing for you to do is click on the fx next to your address bar.
Pick NPV and follow the prompts.

First, you enter the rate. I assume you'll want this to be a value in
another cell, so just click on that cell.

Next, just enter the payments/income for up to 29 periods. Again, you can
reference other cells to populate these values.

HTH!

"sleeplessinnewjersey" wrote:

I need to use the Excel (2002) net present value function. I looked in Help
and was told to copy a table therein to a new worksheet. I did so. However,
I found nothing to guide me in using it. I need to calculate the net present
value of an investment that will produce annual savings over 5 and 10 year
periods. I need to specify the discount rate. Can someone please give me
step-by-step directions?