View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Does how #s are listed affect IRR calc- same #s vertically vs. hor

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

--
Kind regards,

Niek Otten

"esstreet" wrote in message
...
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???