Posted to microsoft.public.excel.worksheet.functions

Debbie Horner Debbie Horner is offline

external usenet poster

Posts: 13

Indirect Function

Hi,

I am trying to use indirect as part of the NPV function for the variable
values to include as the calculation...I get a Value error..can this function
only be used as part of a sum etc...my formula is as follows..
=NPV(C69/12,'Amort schedule'!F4:INDIRECT("f"&LeaseTerm1+3))

Thank you and happy new year!

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
indirect function	ah	Excel Worksheet Functions	1	January 25th 07 12:22 PM
using the INDIRECT function	hot dogs	Excel Discussion (Misc queries)	1	November 1st 06 12:01 PM
Indirect function ?	Carlos Antenna	Excel Worksheet Functions	5	July 4th 06 02:29 AM
Help with INDIRECT function.	DaveO	Excel Worksheet Functions	12	January 18th 06 09:52 AM
Indirect Function and Sum	gr	Excel Worksheet Functions	2	February 2nd 05 04:16 PM

All times are GMT +1. The time now is 03:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us