XIRR Function

Naresh Patel
Naresh Patel used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
You have used the correct formula, the value you are seeing because of negative sum of values throughout the dates.
Naresh PatelFinancial Adviser

Author

Commented:
ohhh that is the case i thought it will produce me negative return %...Thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome.
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Top Expert 2016

Commented:
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
Naresh PatelFinancial Adviser

Author

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
Top Expert 2016

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial