Posted to microsoft.public.excel.misc

Brad

external usenet poster

Posts: 846

XIRR range question

How can I "trick" excel to use non-continuous cell

I would like to have
=xirr(m3:m4 and n5,d3:d5)
or
=xirr(m3:m40 and n41,d3:d41)

I realize that xirr doesn't accept the "and" . I'm including it to help
explain my question.

--
Wag more, bark less

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
XIRR question	ORLANDO VAZQUEZ[_2_]	Excel Discussion (Misc queries)	5	October 8th 09 02:16 PM
XIRR	Rajesh Nathani	Excel Discussion (Misc queries)	1	September 1st 07 01:04 PM
XIRR	Jami	Excel Discussion (Misc queries)	3	August 11th 07 05:25 AM
XIRR	Bob Umlas, Excel MVP	Excel Worksheet Functions	3	January 26th 07 01:58 AM
XIRR - Automating the date range	WTM	Excel Discussion (Misc queries)	0	November 2nd 06 06:49 PM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us