software

Having problem with IRR calc on same set of #s. One set is listed vertically
and one set is listed horizontally. Was essentially just double checking
myself and thought they should be the same but the IRRs were different.
Example the return answer for =IRR(A2:G10) was different than the same
numbers listed vertically and the calc done =IRR(A2:A10). Any help???

The number of figures in the ranges you specify are not the same

--
Kind regards,

Niek Otten

quot;esstreetquot; gt; wrote in message
...
gt; Having problem with IRR calc on same set of #s. One set is listed
gt; vertically
gt; and one set is listed horizontally. Was essentially just double checking
gt; myself and thought they should be the same but the IRRs were different.
gt; Example the return answer for =IRR(A2:G10) was different than the same
gt; numbers listed vertically and the calc done =IRR(A2:A10). Any help???
They are the same- I was just giving an example that did not match my true
calculation. The real formulas are =IRR(D749) and =IRR(E72:AU72). Sorry.
That wasn't really the jist of my problem.
quot;Niek Ottenquot; wrote:

gt; The number of figures in the ranges you specify are not the same
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;esstreetquot; gt; wrote in message
gt; ...
gt; gt; Having problem with IRR calc on same set of #s. One set is listed
gt; gt; vertically
gt; gt; and one set is listed horizontally. Was essentially just double checking
gt; gt; myself and thought they should be the same but the IRRs were different.
gt; gt; Example the return answer for =IRR(A2:G10) was different than the same
gt; gt; numbers listed vertically and the calc done =IRR(A2:A10). Any help???
gt;
gt;
gt;

Have just SUMmed the items (with many decimals displayed in the result) to
check that tey really are exactly the same?

--
Kind regards,

Niek Otten

quot;esstreetquot; gt; wrote in message
...
gt; They are the same- I was just giving an example that did not match my true
gt; calculation. The real formulas are =IRR(D749) and =IRR(E72:AU72).
gt; Sorry.
gt; That wasn't really the jist of my problem.
gt;
gt;
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; The number of figures in the ranges you specify are not the same
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;esstreetquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Having problem with IRR calc on same set of #s. One set is listed
gt;gt; gt; vertically
gt;gt; gt; and one set is listed horizontally. Was essentially just double
gt;gt; gt; checking
gt;gt; gt; myself and thought they should be the same but the IRRs were different.
gt;gt; gt; Example the return answer for =IRR(A2:G10) was different than the same
gt;gt; gt; numbers listed vertically and the calc done =IRR(A2:A10). Any help???
gt;gt;
gt;gt;
gt;gt;