G
Guest
Guest
I'm hoping someone can help.
Is there a way with a function like IRR which only has one argument (e.g. IRR(argument,guess)) to put discontinous cells into that argument. Using a comma doesn't work as it assumes that is the next argument (for IRR the guess return rate).
Example - I would like to find out the IRR for cells A1:A5,C5 (six total cashflows). How can I do this?
Thanks in advance.
Is there a way with a function like IRR which only has one argument (e.g. IRR(argument,guess)) to put discontinous cells into that argument. Using a comma doesn't work as it assumes that is the next argument (for IRR the guess return rate).
Example - I would like to find out the IRR for cells A1:A5,C5 (six total cashflows). How can I do this?
Thanks in advance.