Thread: XIRR
View Single Post
  #2   Report Post  
PC
 
Posts: n/a
Default

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