Conditional Statement/IRR Formula

W

wilson31416

A1 through A20 are a series of cash flows (some negative and som
positiive). In cell B1, I need to write a conditional statement tha
includes only those cash flows from A1 through A20 that will yield
10% (or any other variable target) IRR. Any ideas on how to write th
formula? Thanks
 
Top