XIRR Function

Hi experts,

Will any one help me to find where i am wrong in this formula.XIRR Formula
See Attached

Thanks
EE-Ledger-Return.xlsm
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
You have used the correct formula, the value you are seeing because of negative sum of values throughout the dates.
0
 
Naresh PatelTraderAuthor Commented:
ohhh that is the case i thought it will produce me negative return %...Thanks
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Rgonzo1971Commented:
The result is not correct

pls try
=XIRR(U2:U18,T2:T18,SIGN(SUM(U2:U18))*0.01)

Open in new window

You have to help the function to find the result (-0.39199869) in this case negative

Regards
1
 
Naresh PatelTraderAuthor Commented:
Will You bit Explain on
=XIRR(U2:U18,T2:T18,SIGN(SUM(U2:U18))*0.01)

So i n future i can apply this function as logically ..

Thanks
0
 
Rgonzo1971Commented:
I used the sum of the workflows to see if the result could be more probably being positive or negative then I fill the guess argument whether with 1% or -1% to help the function in the direction of the awaited return
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.