Hi Allan,

IRR can use two columns e.g. IRR(a1:b6) with outgoings in column a and
income in column b.
The easiest case is for the data to be on only one row at a time (outflow or
inflow but not both at the same time).
If there are two values on the same row, it seems that the IRR function
assumes that they occur in two different periods (with the left column first)
rather than as a net flow that occurs in the same period.
If the data actually does have two flows that occur at the same time and are
in the same row (which would be the usual interpretation for two flows on the
same row), the correct result can be obtained by constructing a third column
for the net flows per period (e.g. in c1 = a1 + b1, etc.) and using that new
column for the calculation instead.

Hth
Anthony

"Allan" wrote:

How to calculate the IRR when the outgos are in one column & the income in
another?