Searching For Alternative to Choose Function

[shoaibzaman]

XIRR function works if data and date is limited to one column each.
My data is split across three columns.
For this reason I am using choose function.

But then the formula becomes super long and after a point it is confusing.
So looking for alternatives.

You can refer the attachment.

[Kaper]

If you look for a dozen of periods, it's not that badly long. Column B is always just column B, So a bit shorter version of

Please Login or Register  to view this content.

could be:

Please Login or Register  to view this content.

it's less than 50% of original length (83 vs 182 characters length)