Posted to microsoft.public.excel.worksheet.functions

Dkline

external usenet poster

Posts: 75

Variable Range for NPV

I got it worked out.

=NPV(PV_Liab_Rate,INDIRECT("R"&RowRetYrStart&"C5:R "&RowRetYrEnd&"C5",FALSE))*(1+PV_Liab_Rate)

Thanls for your help.

"Spiky" wrote:

On Aug 26, 4:14 pm, Spiky wrote:
Try the EDATE function. If A1 is the beginning date and B1 is the
number of years.
=EDATE(A1,B1*12)

Forgot: you need the Analysis toolpak if not in Excel 2007.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to specify a range that is variable.	Mal[_2_]	Excel Worksheet Functions	4	April 9th 08 03:39 PM
variable range	John	New Users to Excel	2	July 21st 06 03:42 PM
Variable Range	sep1280	Excel Worksheet Functions	3	March 6th 06 07:17 AM
Variable in Range	aftamath	Excel Discussion (Misc queries)	2	October 6th 05 07:48 PM
How to use a variable for a range	Jeff Lowenstein	Excel Worksheet Functions	1	July 26th 05 02:14 AM

All times are GMT +1. The time now is 07:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us