Thread: Working with arrays as arguments
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Working with arrays as arguments
Hello HB,

Enter
=IRR(TRANSPOSE('Cash Flows'!E9:AE9),0.1)
normally (no array-formula). IRR expects a vertical array input.

Regards,
Bernd
Reply With QuoteReply With Quote