Mixing up the arguments

[michaelr586]

I would like to be able to have an IRR function that has formulas and
numbers inside. For example:

=IRR((-a1,c3,400,d4+f9,e10),0.12)

Of course, Excel doesn't permit this. I tried the value function (i.e.
value(d4+f9)), but it didn't work. What can I do?

 

[Ian]

I don't know the IRR function, but if the only issue is with d4+f9, then use
another cell to sum these then reference the sum cell.

 

[Bob Phillips]

IRR seems to want an array or a range. Can you either put the values in a
contiguous range, maybe creating a range that refers to your values =A1,
=C£,=D4+D9, etc., or pass directly, like

=IRR({-2000,1500,400,2000,2500},0.12)
--
HTH

Bob Phillips

"michaelr586" <[email protected]>
wrote in message
news:[email protected]...