Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

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
0
Naresh Patel
Asked:
Naresh Patel
  • 2
  • 2
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now