If Data validation = Yes, then run formula
Wrap it in another IF:
=IF(A7="Yes",IF(B7<=F7,G7,IF(B7<=F8,G8,IF(B7<=F9,G9,IF(B7>F10,G10)))),"")
Where A7 is the cell that is either Yes or No
If Data validation = Yes, then run formula
Wrap it in another IF:
=IF(A7="Yes",IF(B7<=F7,G7,IF(B7<=F8,G8,IF(B7<=F9,G9,IF(B7>F10,G10)))),"")
Where A7 is the cell that is either Yes or No