[Solved] How to combine "if" and "irr" conditions?

[jeremyethoz]

I have a list of contracts with their associated cash flows in 1 excel.
How do i combine the "if" and "irr" conditions to know the IRR for each contract?

 

[shamimarita]

I have a list of contracts with their associated cash flows in 1 excel.
How do i combine the "if" and "irr" conditions to know the IRR for each contract?

Hello Jeremyethoz,

You can use the combination of IF and IRR functions based on your condition type:
=IF(Conditions, IRR(Cash-Flow Range), "")
=IF(F2, IRR(B2:E2), "")

This formula checks if the condition is TRUE in the F column. It will calculate the IRR for the cash flows in columns B to E for that row. If the condition is FALSE, it returns an empty string.