Hi. I want to change a formula if a condition is met. I'm attaching my workbook. At AL95 the formula is
IF(AM94="",MIN(B$4:B95),MIN(B$55:B95))
If AM94 is 1 I would like the formula to change to
IF(AM94="",MIN(B$4:B95),MIN(B$94:B95))
. How can I do that?

Thanks for any help!
RSX FV ROV add sell calls question.xlsm