About Pricing Community Teams Start Free Trial

Naresh Patel

asked on 8/27/2016

XIRR Function

Hi experts,

Will any one help me to find where i am wrong in this formula.

See Attached

Thanks
EE-Ledger-Return.xlsm

Microsoft Excel

Last Comment

Rgonzo1971

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

8/27/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Naresh Patel

8/27/2016

ASKER

ohhh that is the case i thought it will produce me negative return %...Thanks

Subodh Tiwari (Neeraj)

8/27/2016

You're welcome.

Rgonzo1971

8/30/2016

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

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

Naresh Patel

8/30/2016

ASKER

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

Rgonzo1971

8/30/2016

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

Certified Expert Program

Credly Partnership

Udemy Partnership