XIRR
 

Is there a way to use cells B2,B3 and the sum of C1 and C2 as the values for
the XIRR function? Excel 2000
--
maryj

The inputs for XIRR are

XIRR("values","dates","guess")

Values are a range
Dates are a range (same number of cells as values)
Guess is a single value

So the answer is no. You would then have two values and only one date (or
two dates and only one value) and either way that wouldn't work.

What exactly are you trying to do. Possible someone can help you find a
suitable formula.

PC

"maryj" wrote in message
...
Is there a way to use cells B2,B3 and the sum of C1 and C2 as the values
for
the XIRR function? Excel 2000
--
maryj