We help IT Professionals succeed at work.

XIRR Function

Naresh Patel
Naresh Patel asked
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

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.
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