Does how #s are listed affect IRR calc- same #s vertically vs. hor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
They are the same- I was just giving an example that did not match my true
calculation. The real formulas are =IRR(D7:D49) and =IRR(E72:AU72). Sorry.
That wasn't really the jist of my problem.
 
Have just SUMmed the items (with many decimals displayed in the result) to
check that tey really are exactly the same?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MORE XIRR vs. IRR help 2
RATE v. IRR: which to use? 4
Printing and scaling: why does Excel behave in such a way? PLZ HELP!!! 5
How do I use advance filter correctly? 2
Creating a strange list :S 6
DATEDIF vs. simple difference 5
IRR of McDonalds expansion plan 1
Xbox One S console 8

Back
Top